Fragmentation of Clustered Primary Key

Question

Fragmentation of Clustered Primary Key

Viewing 5 posts - 1 through 6 (of 6 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

How many rows per page?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 2

This has been covered recently - may be of some help:

http://www.sqlservercentral.com/Forums/Topic872069-1550-1.aspx

julian.fletcher SSCrazy Points: 2989 More actions · Answer 3

Thanks for the reference. I'm not sure that explained why you'd get fragmentation on an index consisting solely of an increasing identity column where only inserts were being carried out and no updates.

Or have I missed something? Again.

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 4

There's another one here you may not have seen:

http://www.sqlservercentral.com/Forums/Topic952029-391-2.aspx

Seems to go into a bit more depth - again not sure it if it will answer your question...

julian.fletcher SSCrazy Points: 2989 More actions · Answer 5

Oooh yes, that looks like it might be just the ticket. Thanks very much.