Predictable Index Fragmentation

Question

Post reply

Predictable Index Fragmentation

SQLBOT

SSCrazy Eights

Points: 8014
More actions
October 28, 2008 at 10:03 pm

#192783

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

Viewing 12 posts - 1 through 11 (of 11 total)

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

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 1

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Anipaul SSC-Insane Points: 24681 More actions · Answer 2

Anipaul

SSC-Insane

Points: 24681

October 29, 2008 at 2:53 am

#891074

Good article ...:)

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

Very good article.

Maybe I should start re-testing my defragmentation routines.

[font="Verdana"]Markus Bohse[/font]

ChiragNS One Orange Chip Points: 26137 More actions · Answer 4

A "different" topic to write a article on.

"Keep Trying"

John.Sansom SSCertifiable Points: 7335 More actions · Answer 5

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

Andy Warren SSC Guru Points: 119902 More actions · Answer 6

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

SQLBOT SSCrazy Eights Points: 8014 More actions · Answer 7

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

JamieX Hall of Fame Points: 3763 More actions · Answer 8

Another article to follow on your maintenance jobs and how the testing went?

Nice article!

Andrew..Peterson SSCertifiable Points: 6838 More actions · Answer 9

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.

rufus43 SSC Enthusiast Points: 135 More actions · Answer 10

I thought it would be impossible to find information on "how to fragment indexes". Seems like everyone wants to defrag these days 😀

This will help me test a rewrite of our index maintenance plan.

Thank you.

Nadrek SSC-Insane Points: 20039 More actions · Answer 11

This looks good, and makes sense as well.

For extra credit, include instructions on how to cause OS/filesystem level fragmentation as well :).