I sometimes wonder how some people can claim certain idea’s as the truth, without proper proof. In this case, I heared somebody say “Of course you can’t truncate a table within a transaction, because a truncate is not logged. You will have to use a delete statement.”. Well, that’s just wrong, and Paul Randall provides the proof:

http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-10-When-are-pages-from-a-truncated-table-reused.aspx.

 

 

One thought on “Yes, you can truncate a table within a transaction!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>