• There is an excellent index defrag tool with tons of power that is free from Michelle Ufford. We use it in production here and I cannot say enough good things about Michelle or her indexing SP. Please find it here:

    http://sqlfool.com/2011/06/index-defrag-script-v4-1/

    You need to get this into a scheduled job and run it weekly. If your database is very dynamic, run daily as a scheduled job. You may have a bitter pill to swallow the first time out, but after that the runs will be much shorter and your database will be much better behaved.

    Thanks

    John.