DelZeroSift

A stored procedure to delete zero SIFT records.

It will delete records in small batches and only when the amount of zero SIFT records exceeds 10% of the total records. It will only run for a set amount of hours so it's easy to schedule and can therefore run during the maintenance window.

It will automatically rebuild indexes on sift tables after deletion and can be set up to make log backups during run.

I usually set it up to run daily for a couple of hours per night. It will then gradually minimize the number of zero entries in the database and after an initial hit keep them to a minimum.