Page Splits 1

Question

Post reply

Page Splits 1

Ron McCullough

SSC Guru

Points: 63877
More actions
June 25, 2011 at 3:23 pm

#242861

Comments posted to this topic are about the item Page Splits 1
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Viewing 15 posts - 1 through 15 (of 15 total)

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

Great question Ron. You provided an excellent scenario to understand a concept. Thank you.

M&M

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

mohammed moinudheen (6/26/2011)
Great question Ron. You provided an excellent scenario to understand a concept. Thank you.

The scenario is not mine, but rather one from Paul Randal's blog, so it is he we both should thank.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

M&M SSC-Insane Points: 21700 More actions · Answer 3

bitbucket-25253 (6/26/2011)
mohammed moinudheen (6/26/2011)
Great question Ron. You provided an excellent scenario to understand a concept. Thank you.
The scenario is not mine, but rather one from Paul Randal's blog, so it is he we both should thank.

Ok Ron

M&M

Dhruvesh Shah SSCrazy Points: 2303 More actions · Answer 4

Excellent explanation from Paul, Thanks to both of you Ron & Paul.

I wonder can i add this link to paul's article in to Briefcase?

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 5

Great question, but a bit hard for a Monday morning 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 6

Nice question

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

dmoldovan SSCertifiable Points: 6334 More actions · Answer 7

Thanks to bitbucket and to Paul 🙂

This nice question made my day.

Rafael Krisller Right there with Babe Points: 737 More actions · Answer 8

Rafael Krisller

Right there with Babe

Points: 737

June 27, 2011 at 6:31 am

#1344463

Great.. Great question.

Congratulations!!!

Cliff Jones SSChampion Points: 10577 More actions · Answer 9

Yes, a good question that made me think too hard for a Monday. Thanks!

SQLRNNR SSC Guru Points: 281344 More actions · Answer 10

Nice question. Thanks

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Surii Default port Points: 1497 More actions · Answer 11

Surii

Default port

Points: 1497

June 27, 2011 at 12:58 pm

#1344742

Good question.

Ken SSCoach Points: 17191 More actions · Answer 12

Wow, very nice. Great example, good to know info. Thanks to both you and Paul.

ma-516002 Hall of Fame Points: 3359 More actions · Answer 13

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

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 14

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.