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...

GSquared (3/31/2009)

---

On the question about nolock selects being deadlocked, first, they can be deadlocked by something else that's locking resources they need, second, if the select is part of an...

Also,

Since i am using the ROWLOCK for updates : what is the effect of say 50 row level locks in a table at a time ?

GSquared (3/30/2009)

---

Santa Ana (3/27/2009)

---

A question gents :

If i place a NOLOCK for an update on a row (Update triggered by the background process) Say Transaction 1

If there is a ROWLOCK...

A question gents :

If i place a NOLOCK for an update on a row (Update triggered by the background process) Say Transaction 1

If there is a ROWLOCK for another update...

GSquared (3/27/2009)

---

Nolock doesn't really do anything to updates at all. Won't do what you need.

For example, user A takes a look at row 3 of table X. Meanwhile,...