• Ninja's_RGR'us (4/22/2010)


    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.

    yep.. i thought that 'truncate' would never rollback. That was the way i was taught in past. You proved that wrong for me now. Thanks for the support links... Really, they helped me a lot and it added value:cool: to me when i discussed this Myth;-) point with my friends..

    - Swaroop R -