• I do not understand what you mean by batch based. You can issue only one delete statement with the datetimestamp in the WHERE clause and it will be one batch.

    If you are worried about the transaction log growth of a huge DELETE statement, you can split it into different smaller transactions by altering the where clause and put it through a loop.

    There is no way that you can turn of logging to speed the process up, but you can possibly alter your design (you mention you have a table for each day?) to truncate the whole table and it should be much quicker.