Home Forums SQL Server 2005 SQL Server 2005 General Discussion how to List out all tables indexes having index fragmentation more than 50% of databases. RE: how to List out all tables indexes having index fragmentation more than 50% of databases.

  • December 17, 2013 at 6:45 am

    #1674047

    I could not get this to work if the DB is running in SQL 2000 compatibility mode. I think for that the script needs to be changed a bit. Otherwise works well.