Did this ever happen to you?
You are debugging, and you are in a transaction, and you want to check something in one of the tables. You try a select:
select * from Something
but it does not work: it will freeze because it's waiting for the transaction to end.
Here is the solution:
select * from Something with(nolock)
This will tell SQL Server that you are not interested in participating in the locking contest, and it will give you the information even if the transaction has a lock over that table.
Subscribe