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…
Category: READ_COMMITED_SNAPSHOT v/s NOLOCK deadlocks
