First published on TECHNET on Aug 31, 2010
Last update to script 1Nov2011.
Maintaining indexes is a primary duty of Database Administrators, becaus...
Updated Mar 23, 2019
Version 2.0
Blog Post
This article was extremely helpful. Thank you for sharing. I did have a question about your select query. It returns just about everything I receive from the SQL index fragmentation report, but I see several items in the index_name that have NULL values for some reason after running the query. I checked to see if any odd symbols. Only thing I can think of is numbers throwing it off. Any suggestions?
The link for Defrag Indexes v5.sql also results in a
XML Resource Not Found Error
Was hoping I might be able to get access to this .sql file.
The sql file can be found in the web archive https://web.archive.org/web/20200801070553/https://msdnshared.blob.core.windows.net/media/TNBlogsFS/prod.evol.blogs.technet.com/telligent.evolution.components.attachments/01/7622/00/00/03/35/29/73/Defrag_Indexes_v5.sql
