SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Leave a Comment

Please register or log in to leave a comment.