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

Content with tags T-SQL, delete Rss

   Items 1 to 13 of 13   
 

Delete v Truncate

By Naseer Ahmad 2013/03/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,421 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,926 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2013/03/06 | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 12,569 reads

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,334 reads

Difference between Truncate and Delete

This article explains you the differences between the Truncate and Delete commands in SQL.  Read more...
By Prashant Pandey 2011/07/04 (first published: 2007/11/22) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 27,669 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,926 reads

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,212 reads

The DELETE statement in SQL Server

Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd considering the extra power conferred on the statement by the addition of the WITH common_table_expression; and the OUTPUT clause that essentially allows you to move data from one table to another in one statement.   Read more...
By Additional Articles 2010/12/13 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,832 reads

Identity Crisis

By dun 2009/10/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,771 reads

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,212 reads

The Safe and Easy Way to Delete All Data in a SQL Server DB

Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.   Read more...
By Additional Articles 2009/03/03 | Source: DevX | Category: t-sql
Rating:  Rate this |   Briefcase | 4,172 reads

Deleting Batches of Rows with TOP

Using the TOP clause in a procedure to delete records in batch.  Read more...
By Ted Manasa 2008/07/03 | Source: SQLServerCentral.com | Category: top
Rating: |  Discuss |   Briefcase | 10,580 reads

Difference between Truncate and Delete

This article explains you the differences between the Truncate and Delete commands in SQL.  Read more...
By Prashant Pandey 2011/07/04 (first published: 2007/11/22) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 27,669 reads
   Items 1 to 13 of 13   
 
Tags
truncate table (2)    
identity property (1)    
locking (1)    
purge (1)    
sql server 2000 (1)    
sql server 2005 (1)    
top (1)    
truncate (1)