<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Craig Outcalt
»
Predictable Index Fragmentation
12 posts, Page 1 of 2
1
2
»»
Predictable Index Fragmentation
Rate Topic
Display Mode
Topic Options
Author
Message
SQLBOT
SQLBOT
Posted Tuesday, October 28, 2008 10:03 PM
SSChasing Mays
Group: General Forum Members
Last Login: Monday, February 18, 2013 3:22 PM
Points: 626,
Visits: 835
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
Jeff Moden
Jeff Moden
Posted Tuesday, October 28, 2008 10:05 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:35 PM
Points: 33,107,
Visits: 27,029
Nice job, Craig... and great graphics! I'm gonna have to play... :)
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #593368
Anipaul
Anipaul
Posted Wednesday, October 29, 2008 2:53 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,813,
Visits: 1,343
Good article ...:)
Post #593433
MarkusB
MarkusB
Posted Wednesday, October 29, 2008 3:08 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 4,222,
Visits: 3,881
Very good article.
Maybe I should start re-testing my defragmentation routines.
Markus Bohse
Post #593438
ChiragNS
ChiragNS
Posted Wednesday, October 29, 2008 5:03 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365,
Visits: 1,825
A "different" topic to write a article on.
"Keep Trying"
Post #593476
John.Sansom
John.Sansom
Posted Wednesday, October 29, 2008 5:56 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 343,
Visits: 1,466
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.sqlbrit.com
Post #593503
Andy Warren
Andy Warren
Posted Wednesday, October 29, 2008 9:55 AM
SSCertifiable
Group: Moderators
Last Login: Tuesday, June 11, 2013 6:34 AM
Points: 6,463,
Visits: 1,388
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
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter
Post #593735
SQLBOT
SQLBOT
Posted Wednesday, October 29, 2008 10:35 AM
SSChasing Mays
Group: General Forum Members
Last Login: Monday, February 18, 2013 3:22 PM
Points: 626,
Visits: 835
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
JamieX
JamieX
Posted Wednesday, October 29, 2008 11:25 AM
Old 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
Andrew Peterson-472853
Andrew Peterson-472853
Posted Thursday, October 30, 2008 10:38 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, January 16, 2013 7:40 AM
Points: 136,
Visits: 259
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 »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
