http://www.sqlservercentral.com/blogs/vinaythakur/2010/11/30/nolock-_1320_-truth/
Printed 2013/05/25 08:35PM
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 →
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.