Press "Enter" to skip to content

Deleting in Batches

Jana Sattainathan gives us a few options to delete data in a way which avoids major log growth:

Today, I had to perform a DELETE that happened to remove quite a bit of data. This caused two issues for me

1. Log file growth which fills up the Transaction Log of the DB
2. TempDB was getting full

To avoid both problems I deleted in chunks.

Click through for two ways of doing it.