Truncate vs Deletion : Definition , and comparisson

DELETION : Will delete records one by one and makes an entry point for each and every deletion in the transaction log.

Truncate : Truncate will de-allocates pages and makes an entry for de-allocation of pages in the transaction log.

Image result for sql delete , truncate

However, there’s no difference between TRUNCATE and DELETE in term of rollback. Since, we can rollback with both of them as long as the commands are started inside the transaction

Leave a comment