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
Totally agreed. In between, also there should be a proper way to write your DML commands in a way that under any case you not accidentally press "F5" without selecting "WHERE" condition. I have seen one of my friend doing it accidentally after which he changed his way of writing code.