SQLServerCentral: Content tagged T-SQL, delete

Delete v Truncate

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,376 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,086 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,190 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,528 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,376 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 | 48,138 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,709 reads

Identity Crisis

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 | 48,138 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,077 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,405 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,528 reads

Content with tags T-SQL, delete