Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

Comments

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.