Going through my daily run of articles, I found this interesting article on the SQL TRUNCATE vs DELETE commands. I was asked several months back whene someone asked me the difference to which I responded that “The difference is that TRUNCATE is not logged”. As you can see from this article, a) I was wrong and B) it gets a little more complicated. Not being afraid of being wrong, I’m just glad to be able to present the correct and detailed answer: http://www.sqlservercentral.com/articles/delete/61387/
Month: July 2011
To DELETE or to TRUNCATE that is the question
Going through my daily run of articles, I found this interesting article on the SQL TRUNCATE vs DELETE commands. I was asked several months back whene someone asked me the difference to which I responded that “The difference is that TRUNCATE is not logged”. As you can see from this article, a) I was wrong and B) it gets a little more complicated. Not being afraid of being wrong, I’m just glad to be able to present the correct and detailed answer: http://www.sqlservercentral.com/articles/delete/61387/
Matthew Verity 