Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Heap has same page count, fewer fragments RE: Heap has same page count, fewer fragments

  • May 2, 2016 at 4:52 pm

    #1876127

    Run this:

    ALTER INDEX IndexName ON SchemaName.TableName REBUILD

    Check the fragmentation stats.

    Now let them defragment the HEAP to match the outcome.

    _____________
    Code for TallyGenerator