I was wondering if you could clear up a issue someone once raised with me. The chap told me one of the other differences between a Truncate and a Delete relates to the effect on full recovery models.Is it true that using a truncate against a Full recovery model has a detrimental effect on restores in that the transaction logs are messed up?

Thanks for this wonderful article. I learned a lot. and you looked at the differences from many points of view.I wanted to rate this article a 5 star. I did something wrong with my mouse and Awful was all I could select. I can't modify the rating any more. So the awful is from me and it should mean "awful good"! Thanks for taking your time to write such a good article.

Excellent explanations especially the logging behaviour of both commands. I was hoping I would have saw some details on the behaviour of these commands on temporary tables. Feel free to let me/us know (via a forum post) if you enhance your article with this info as well.