Lynn Pettis

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: )

51,866 reads

Blogs

Daily Coping 2 Jul 2020

By

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

Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting

By

Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...

MVP for Another Year 2020-2021

By

Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...

Read the latest Blogs

Forums

Unusual use of the WHERE clause

By michael.leach2015

I am working an exercise problem where the solution provided has a WHERE clause...

How to get the SSAS Server administrators in MDX query?

By sabarishbabu

Hello, Is there any way to get the list of server administrators from SSAS...

Upgrading from SQL Server 2012 to SQL Server 2017 - Any Tips or Gotchas

By HookSQLDBA7

We are running SQL Server 2012 SP4 Standard Edition on Windows Server 2012 R2...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers