Pros & Cons of TRUNCATE vs DELETE FROM
TRUNCATE doesn’t generate any rollback data, which makes it lightning fast. It just deallocates the data pages used by the table. However, if you are in a transaction and want the ability to “undo” this delete, you need to use DELETE FROM, which gives the ability to rollback. EDIT: Note that the above is incorrect … Read more