chandan_jha18 (11/7/2013)

---

sqlnaive (11/7/2013)

---

Interesting read. Gives the pretty much idea on what you can end up into if not consider the impact of the DML.

Burned my hands with heavy deletes once, so always performed this operation in batches thereafter so that even if it had to rollback for whatever reason, it can do it fast enough plus doing it this way controls your CPU else delete operation is just nasty.

Cheers!!

Chandan