SQLServerCentral.com Articles tagged delete

Deleting large number of rows from a table in a VLDB

Fri, 08 Mar 2013 07:00:00 UT

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.

Hidden Tricks To SQL Server Table Cleanup

Wed, 06 Mar 2013 07:00:00 UT

How to delete millions of rows with virtually no contention.

Large table cleanup with minimal locks

Tue, 06 Mar 2012 07:00:00 UT

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.

Options to not replicate SQL Server DELETE commands

Fri, 04 Nov 2011 06:00:00 UT

I have transactional replication configured in my production environment. The business team has requested that I do not replicate delete operations on certain articles. In this tip we look at a couple of options to not replicate DELETE commands.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Difference between Truncate and Delete

Mon, 04 Jul 2011 06:00:00 UT

This article explains you the differences between the Truncate and Delete commands in SQL.

Deleting large number of rows from a table in a VLDB

Fri, 08 Mar 2013 07:00:00 UT

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.

Deleting Large Number of Records

Fri, 18 Feb 2011 07:00:00 UT

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

Automated Trigger To Require a WHERE Clause

Tue, 25 Jan 2011 07:00:00 UT

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.

The DELETE statement in SQL Server

Mon, 13 Dec 2010 07:00:00 UT

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.

Deleting Large Number of Records

Fri, 18 Feb 2011 07:00:00 UT

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

Tue, 03 Mar 2009 07:00:00 UT

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.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Deleting Batches of Rows with TOP

Thu, 03 Jul 2008 06:00:00 UT

Using the TOP clause in a procedure to delete records in batch.

Difference between Truncate and Delete

Mon, 04 Jul 2011 06:00:00 UT

This article explains you the differences between the Truncate and Delete commands in SQL.