Subscribe to this blog
Briefcase
Print
NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that you don’t expect consistency, so there are no guarantees. Bear in mind though that “inconsistent data” does not only mean … Continue reading
Posted by Tim Mitchell on 9 December 2010
Not to mention that NOLOCK is a hint, not a directive, so the results could be inconsistently inconsistent.