SQL Swiss Army Knife #7 - Adaptive Index Defrag
Hello all,
Sorry for the inconvenience, but the content of this post moved to the Adaptive Index Defrag post.
Comments
- Anonymous
March 13, 2011
FYI, so you don't reinvent the wheel, but there's already a very good solution at:sqlfool.com/.../index-defrag-script-v4-0I've been using this for a few years now without issue. - Anonymous
March 14, 2011
Hello Tom,Thank you for your feedback. The script you have indicated is indeed very good, no dispute there.The fact is, because I have not found one out there that managed all I needed it to do, like stats update or disctinct ways to deal with partitions, amongst other things, I came up with one of my own and decided to share.