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