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.
Posted
08-09-2009 11:44
by
robp