I discuss ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.

See how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.