SQL Clone
SQLServerCentral is supported by Redgate
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,821 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 | 905 reads

Best Practice

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