Page Splits 1

• chrisfradenburg

  SSCrazy Eights

  Points: 9592

  More actions

  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.