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)

2011-02-18 (first published: )

52,953 reads

Blogs

Techorama 2022 Slides

By

I had a great time at Techorama. I’ll do a writeup on the event,...

Daily Coping 27 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

The 2022 Preview

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The 2022 Preview

OLE DB provider \"SQLNCLI11\" for linked server

By EasyBoy

We have a DTS package running on one of the production server. This is...

Need to provide access to database without giving access to production

By gray6

Hoping I could find some best practice answers here: We have analysts who need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers