Currently browsing tag

SQL Server

SQL Server Best Practices

There is nothing better than knowing exactly what needs to be done to get the best results from your technology. Especially from …

MS SQL Cursors are Evil

Alright, they’re necessary at times, but for the most part you need to really avoid them. It’s not about the coding and …

SQL Recompiles

Here are some articles that describes the need to reference the owner (schema) of SQL Server stored procedure when called by applications. …

SQL Server Linked Server to Oracle

As a database administrator by trade, I have had a very perplexing task to have my SQL Server 2005 Enterprise servers communicate …