Avoiding deadlocks using new READ_COMMITED_SNAPSHOT isolation level in SQL 2005

Programmer A: There’s a deadlock happening when this procedure is run ProgrammerB: Did you try using NOLOCK hint in SELECT statements? It should prevent most deadlocks from happening … How many times have we heard the above type of conversation…

Importance of specifying length in datatypes

This post is just to emphasize on importance in specifying length while declaring fields,variables or parameters. I have seen quite a few occasions where developers have ignored length part. The problem is depicted below select CAST(‘12.34354’ as numeric) ————————————— 12…