I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using GetDate(). Pretty straight forward right? Well originally the job consisted of 6 different statements like so: delete from table1 where column_with_date <= DATEADD(mm,-13,GETDATE()); Except, the tables have become so large the generic deletes were filling up tempdb.