http://www.sqlservercentral.com/blogs/vinaythakur/2010/11/30/nolock-_1320_-truth/

Printed 2014/07/24 05:20PM

NOLOCK – truth

By Vinay Thakur-585143, 2010/11/30

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.