Lynn Pettis

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

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

Blogs

Daily Coping 3 Dec 2020

By

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

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

[Video] Azure SQL Database – Import a Database

By

Quick Video showing you have to use a BACPAC to “import” a database into...

Read the latest Blogs

Forums

How can I exclude records from this table?

By NineIron

How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...

Disable Package Expression

By DinoRS

Hi SSC, I've got 2 Project Variables which I use to control wether a...

Inflow / outflow report per day

By milo1981

Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers