Quote Originally Posted by PAVB
delete statement is not a pretty solution no matter how you wrap it.

Massive purging calls for a structure that allows massive purging in an easy, fast and scalable way.

The answer is partition your table and indexes in a way you have to just truncate a single partition a day.
It is more work than a quick fix to your DML, but it IS the right way to go. Tinkering with the DELETE statement is not going to solve your problems.

If you can't see your way to creating a partitioned table, then you will have to create separate tables, flip flopping between inserting into one then into another. The data you don't want you can remove through a TRUNCATE. It will work, but would be horrible.