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

Content with tags T-SQL, Locking Rss

   Items 1 to 3 of 3   
 

Large table cleanup with minimal locks

How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.  Read more...
By Edward Polley 2012/03/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,355 reads

Switching tables

Switching tables describe the scenario of 2 tables containning data; while making a process on one tables the other table can continue and function in front of some application.  Read more...
By tomer lev 2008/09/05 | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 886 reads

Best Practice

By Sergiy 2008/09/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,193 reads
   Items 1 to 3 of 3   
 
Tags
administration (1)    
delete (1)    
multi process (1)    
tables (1)