Post reply

Page Splits 1

  • June 28, 2011 at 7:45 am

    #1345187

    ma-516002 (6/28/2011)

    Interesting question. I relied on another block http://sqlfool.com/2009/04/page-splitting-rollbacks/ which says the opposite.

    That article says that it's not rolled back too:

    So what's this all mean? In short, page splits are NOT reversed when a transaction is rolled back. Why should you care? Well, you probably wouldn't care much, unless you roll back a lot of transactions. But this is also a good thing to keep in mind if you have to abort a really large insert or update; if you don't plan to re-execute the aborted script, you may want to defrag your indexes to fix the splits.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply