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 4 of 4   


By Sergey Gigoyan 2015/08/04 | Category: table hints
Rating: (not yet rated) |  Discuss |   Briefcase | 1,428 reads

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: | Category: nolock
Rating: (not yet rated)  Rate this |   Briefcase | 4,405 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: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,477 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: | Category: nolock
Rating:  Rate this |   Briefcase | 6,404 reads
   Items 1 to 4 of 4   
blogs (1)    
dirty read (1)    
hints (1)    
isolation levels (1)    
read uncommitted (1)    
readpast (1)    
table hints (1)