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

Blogs

SQL Server on Linux Storage Secrets on Microsoft Channel 9

By

I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...

Daily Coping 29 Jul 2021

By

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

Server vs Instance. A rant.

By

It’s a SQL Server Instance not a SQL Server. The product is SQL Server....

Read the latest Blogs

Forums

How to limit SQL Job Success events

By Graham Van der vaart

Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...

SQL Server Agent producing unreproducible error

By Thom A

I've built a Powershell script, which I want to run through SQL Server Agent....

Replace hexidecimal value wih '§' or blank in a TEXT field

By Edvard Korsbæk

I have a DB with a field defined as: dag_text text allow nulls I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers