共用方式為


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.