Home Forums SQL Server 2005 Administering Best Index Rebuild/Reorganize and Update Statistics Strategy RE: Best Index Rebuild/Reorganize and Update Statistics Strategy

  • July 21, 2013 at 9:55 am

    #1634314

    SQL_Surfer (7/21/2013)

    Thanks Gail. Should I expect 10GB growth everytime I rebuild the index?

    No, you should expect the file to grow if there's not enough free space for new indexes to be created. If there is enough free space, then there's enough free space and there's no need to grow the file.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass