9Jul/093
Index Defrag Script Update
A couple of people pointed out to me that the stats rebuild feature in my defrag script will only complete for one database. Whoopsies! I've fixed the bug and updated the script in my previous post, so if you're using my defrag script, please update it. Thanks to Derick and SuperCoolMoss for letting me know about the bug.
I've also received a couple of other requests for feature enhancements. I'm currently swamped at work and outside of work, but as soon as I get time, I will release the latest version. Realistically, it'll probably be sometime after summer ends.
Thank you to everyone for their comments and suggestions!
Tagged as: defrag, defragment, indexes, script, T-SQL Scripts, TSQL
Leave a comment
Categories
- Business Intelligence
- Internals
- Miscellaneous
- PASS
- Performance & Tuning
- Presentations
- SQL 2008
- SQL Tips
- Syndication
- T-SQL Scripts
Subscribe to my blog!
| Like what you see? Subscribe! |
![]() |
Around the Web
Recent Tweets
- RT @Phil_Factor: SQL Server table columns under the hood http://t.co/vp7gQ77B < what a great post
- @tradney haha that's awesome :)
- OH: @AdamMachanic's #sqlpass session was one of the best I've ever seen.
Archives
- November 2011
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008



July 10th, 2009 - 00:54
Thanks Michelle, the update has work successfully. Who’s jbelina?
Regards,
SCM
July 11th, 2009 - 08:47
Thanks, SCM. He’s a co-worker of mine; I must’ve accidentally clicked on his username in the “submitted by” part. Fixed now, thanks for pointing that out!
July 20th, 2009 - 06:37
Great script Michelle. Thank you.