InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 01:13:17 GMT20http://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxThis looks good, and makes sense as well.For extra credit, include instructions on how to cause OS/filesystem level fragmentation as well :).Wed, 01 Feb 2012 14:55:23 GMTNadrekhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxI thought it would be impossible to find information on "how to fragment indexes". Seems like everyone wants to defrag these days :-DThis will help me test a rewrite of our index maintenance plan.Thank you.Wed, 17 Nov 2010 05:52:38 GMTrufus43http://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxNice academic approach. No doubt I'll have to look this over a few times for it all to sink in.Thu, 30 Oct 2008 10:38:00 GMTAndrew Peterson-472853http://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxAnother article to follow on your maintenance jobs and how the testing went?Nice article!Wed, 29 Oct 2008 11:25:50 GMTJamieXhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspx[quote][b]Andy Warren (10/29/2008)[/b][hr]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.[/quote]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'.Wed, 29 Oct 2008 10:35:39 GMTSQLBOThttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxLooking 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.Wed, 29 Oct 2008 09:55:58 GMTAndy Warrenhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxAn 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.Wed, 29 Oct 2008 05:56:48 GMTJohn.Sansomhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxA "different" topic to write a article on.Wed, 29 Oct 2008 05:03:13 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxVery good article. Maybe I should start re-testing my defragmentation routines.Wed, 29 Oct 2008 03:08:01 GMTMarkusBhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxGood article ...:)Wed, 29 Oct 2008 02:53:49 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxNice job, Craig... and great graphics! I'm gonna have to play... :)Tue, 28 Oct 2008 22:05:00 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic593367-1403-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Index+fragmentation/64424/">Predictable Index Fragmentation</A>[/B]Tue, 28 Oct 2008 22:03:27 GMTSQLBOT