Home Forums SQL Server 7,2000 Administration DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES question RE: DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES question

  • Thanks!

    I did a DBREINDEX on all tables in my DB (individually) using this format:

    use MYDB

    DBCC DBREINDEX ('MYDB.Territories', '', 70)

    After doing this, the logical fragmentation and extent fragmentation numbers are still VERY high.. like 98 and 99%????