Home Forums SQL Server 2008 SQL Server 2008 - General Trying to understand non-clustered index Fragmentation RE: Trying to understand non-clustered index Fragmentation

  • January 22, 2013 at 12:29 pm

    #1579796

    Robert Davis (1/22/2013)

    There must simply not be enough contiguous free space for it to rebuild it unfragmented.

    I've seen indexes rebuild fragmented before, but never this bad.

    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