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

Content with tag Table Hints Rss

   Items 1 to 2 of 2   
 

READPAST vs. NOLOCK

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

Using NOLOCK and READPAST table hints in SQL Server

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server  Read more...
By Additional Articles 2008/07/15 | Source: Builder.com | Category: isolation levels
Rating:  Rate this |   Briefcase | 5,139 reads
   Items 1 to 2 of 2   
 
Tags
isolation levels (2)    
dirty read (1)    
nolock (1)    
performance tuning (1)    
readpast (1)