Question: what is the difference between truncate and delete sql server?
Answer: DELETE deletes records one by one and makes an entry for each and every deletion in the transaction log, whereas TRUNCATE de-allocates pages and makes an entry for de-allocation of pages in the transaction log. There is also a lot of misconception among people about rolling back after a TRUNCATE or DELETE.