Home > SQL Server > Yes, you can truncate a table within a transaction!

Yes, you can truncate a table within a transaction!

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.

Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.