Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a question
To: William Assaf
Subject: dba has a question
William,
Can you send me references to support my contention that NOLOCK is the epitome of evil?
That is, that it can return invalid and/or unrelated data.
He is still suggesting that folks use NOLOCK (rather than READPAST).
We have to work around other poorly written queries, so some of these are inevitable.
Thanks,
[my colleague's name redacted to protect the innocent]