• Just... keep simple!

    If you need to delete a large number of rows and the scenario don't need to keep the database log.

    In this case I want to delete all the rows between 2009/01/01 and 2009/10/23, about 100000000 rows.

    delete top (10000) from myTable where colDate between '20090101' and '20091023'

    backup log myDatabase with no_log

    go 10000

    What you think?

    P.S. The recovery model is SIMPLE.