Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ninja's_RGR'us Truncate rollback RE: Truncate rollback

  • April 22, 2010 at 1:20 pm

    #1156394

    David_Simpson (4/22/2010)

    If you really need the points... you can have mine. I've tried spending them at Walmart but they wouldn't take them. 😉

    Speaking of learning something, Paul Randal has some great articles on what happens during a TRUNCATE statement on his blog.

    http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281930%29-TRUNCATE-TABLE-is-non-logged.aspx

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

    David

    :hehe::hehe::hehe::-P:-P:-D:-D

    Thanks for the links... I'm sure many of us need to read this.