Lynn Pettis

  • Interests: Sci Fi, Fantasy, Swords and Sorcery, Computers, Soccer (coach and ref)

SQLServerCentral Article

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

3.11 (111)

You rated this post out of 5. Change rating

2011-02-18 (first published: )

53,694 reads

Blogs

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

Gentlest of Reminders, Don't Stop Learning

By Grant Fritchey

Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers