Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Nolock Rss

   Items 1 to 3 of 3   
 

Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

Occasionally I come across UPDATE and DELETE statements where the target SQL Server table is referenced with the NOLOCK hint. Does this hint help or hurt performance in this case?  Read more...
By Additional Articles 2014/03/03 | Source: MSSQLTips.com | Category: nolock
Rating: (not yet rated)  Rate this |   Briefcase | 4,151 reads

SQL SERVER : The Scene Behind NOLOCK

I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...  Read more...
By 2012/07/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,867 reads

Understanding the SQL Server NOLOCK hint

It seems that in some SQL Server shops the use of the NOLOCK (aka READUNCOMMITED) hint is used throughout the application. In this tip we take a closer look at how this works and what the issues maybe when using NOLOCK.  Read more...
By Additional Articles 2011/08/24 | Source: MSSQLTips.com | Category: nolock
Rating:  Rate this |   Briefcase | 6,335 reads
   Items 1 to 3 of 3   
 
Tags
blogs (1)    
hints (1)    
read uncommitted (1)