• Zach,

    Interesting approach but is there a way to script the commands out as CREATE INDEX...WITH (DROP_EXISTING=ON) ON [FILEGROUP] instead of dropping the indexes first and then creating the new ones? I explored drop & create vs. create with drop_existing in this blog post and found that drop & create is 2-3X costlier in reads, CPU, and duration.

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]