Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.
In the first part of this series, we saw how the Halloween Problem applies to UPDATE queries. In this post, we will see how the same underlying issue can affect INSERT and DELETE statements.