GilaMonster (3/3/2013)

---

aviadavi (3/3/2013)

---

I'm using NOLOCK because integrity is not that important for me and again - I want good timing and i want to avoid potential deadlock by not locking the rows I select.

So in other words you'd rather get incorrect data fast than correct data slightly slower?

I take it that you ignored all the advice we gave you last time you asked about this query (remove the rowlock, remove the nolock, optimise the query and tune the indexes).

http://www.sqlservercentral.com/Forums/Topic1424131-391-1.aspx