Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Predictable Index Fragmentation Expand / Collapse
Author
Message
Posted Tuesday, October 28, 2008 10:03 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
Comments posted to this topic are about the item Predictable Index Fragmentation

Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #593367
Posted Tuesday, October 28, 2008 10:05 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:11 PM
Points: 35,769, Visits: 32,432
Nice job, Craig... and great graphics! I'm gonna have to play... :)

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #593368
Posted Wednesday, October 29, 2008 2:53 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:15 AM
Points: 5,471, Visits: 1,402
Good article ...:)


Post #593433
Posted Wednesday, October 29, 2008 3:08 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
Very good article.
Maybe I should start re-testing my defragmentation routines.


Markus Bohse
Post #593438
Posted Wednesday, October 29, 2008 5:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
A "different" topic to write a article on.

"Keep Trying"
Post #593476
Posted Wednesday, October 29, 2008 5:56 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 6:03 AM
Points: 351, Visits: 1,556
An excellent article that I really enjoyed reading, so thank you for sharing it with us. I particularly like your clear and logical writing style.

I look forward to reading more of your work.



John Sansom (@sqlBrit) | www.johnsansom.com
Post #593503
Posted Wednesday, October 29, 2008 9:55 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 7:34 AM
Points: 6,804, Visits: 1,933
Looking forward to trying it as well. I've always used the example of updating a uniqueidentier column with all new values from newid() to generate fragmentation and show to use fill factor to offset it, this should be an interesting approach to add to that.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #593735
Posted Wednesday, October 29, 2008 10:35 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
Andy Warren (10/29/2008)
Looking forward to trying it as well. I've always used the example of updating a uniqueidentier column with all new values from newid() to generate fragmentation and show to use fill factor to offset it, this should be an interesting approach to add to that.


oh, that's clever!

I'll have to see what the graph looks like.


At the end of the day, I think understanding this sort of thing helps design better tables and indexes.
I know I've been thinking about it more and more... especially with ETL jobs which could fragment horribly if you inserted them 'wrong', but fragment relatively little if inserted 'right'.


Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #593782
Posted Wednesday, October 29, 2008 11:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 15, 2010 8:23 AM
Points: 371, Visits: 437
Another article to follow on your maintenance jobs and how the testing went?

Nice article!
Post #593818
Posted Thursday, October 30, 2008 10:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 12, 2014 9:23 AM
Points: 206, Visits: 402
Nice academic approach. No doubt I'll have to look this over a few times for it all to sink in.

The more you are prepared, the less you need it.
Post #594533
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse