Home Forums SQL Server 2005 Administering with nolock in sql server please advice RE: with nolock in sql server please advice
dtevlin
Ten Centuries
Points: 1084
More actions
January 28, 2008 at 1:35 pm
#772626
Be aware that you can get duplicate data back in a query using NOLOCK.
Itzik Ben Gan demoed this and you can find a code example here.
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx
--Dave