Does the WITH (NOLOCK) option work with sql server 2005 ?
Or is it depricated ?
I was facing some serious deadlock issues in a high transaction table, i was not bothered about inaccurate data, i added nolock to a select statement.
Even after i added nolock directive to my select, this select statement becomes a deadlock victim at times.
I do not understand why and how can this happen? ( a select with nolock is not locking anything at all, how does it participate in a dead lock situation ? )
can someone throw some light on this please ?
fyi. there could be other transactions that update the data that the select with nolock transaction is trying to select.
Thanks in adv.
appreciate your help.