Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Reorganze index and Statistics RE: Reorganze index and Statistics

  • March 27, 2013 at 12:37 pm

    #1601315

    opc.three (3/27/2013)

    At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your index, ie only the partitions that need it.

    Or switch to bulk-logged recovery model if possible.

    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