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 a database server. Why wouldn’t someone read the
Tag: SQL Server
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 numeric or vachar to int or varchar 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 is definately a slick way to build on
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 simplicity of using them, it’s about the impacts
SQL Recompiles
Here are some articles that describes the need to reference the owner (schema) of SQL Server stored procedure when called by applications. Also, making sure that the calls are sensitive
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 a foreach( on ActiveDB.StoredProcedures). Could not load file
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 and schema to support the GMT/UTC baseline and
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 with my Oracle 10g box and gather data