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 …
SQL Cast from Varchar to Numeric
If you are working a lot with numbers in SQL Server or other database, sometimes it’s necessary to cast a text to …
SQL variables can act on each other
There are many situations when you have a variable in a stored procedure and you want to add to it. Well, there …
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. …
SMO SQL Server Error Reading Stored Procedures Collection
The following error is appearing while running Visual Studio 2005 and developing an application with SMO capabilities. It appears when trying perform …
SQL Server 2005 Agent Schedule Not Updating
Ewwwh, this was a nasty little bug. Let me describe the title … I was having to update all our database data …
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 …