Nibbling Deletes - Intro

re: Nibbling Deletes - Intro

Paul Ballew — Tue, 20 Sep 2005 20:16:08 GMT

The ROWCOUNT and WAITFOR DELAY seem to be the trick here. With this approach, would you run the "nibble" constantly throughout the day, like every minute or every 10 minutes? Is there a way to run it as a continuously-running job? I'd be inclined to run it after hours and have it run until ROWCOUNT is 0. Still using a TOP of course, so it's not selecting too much data at once, but re-running the procedure until 0 rows are deleted.

re: Nibbling Deletes - Intro

RepeatableRead — Tue, 20 Sep 2005 20:24:51 GMT

You can run these just about any time. I've usually scheduled them to run during the night, etc. But you could easily schedule them to run every hour, or whatever is needed. The beauty is that it will keep deleting, slowly but surely, until all of the rows are gone. So, however often you need it to run, you can.

Deleting/archiving data in SQL Server 2005

SimonS' SQL Server Stuff — Fri, 11 Nov 2005 00:16:31 GMT

Michael Campbell has blogged about removing data from a table in chunks http://sqladvice.com/blogs/repeatableread/archive/2005/09/20/12795.aspx....

Deleting/archiving data in SQL Server 2005

simonsabin — Fri, 02 Dec 2005 20:35:04 GMT