Home Forums SQL Server 2016 SQL Server 2016 - Administration Index Framentation RE: Index Framentation

  • February 28, 2018 at 7:59 am

    #1981465

    Perry Whittle - Wednesday, February 28, 2018 6:45 AM

    tmmutsetse - Monday, February 5, 2018 6:16 AM

    Hi,
    I have tables in databases with avg_fragmentation of 86% and a page count of 26 and even less page count on some tables.I set up a job to rebuild and organise these indexes using Ola's script.There is no change after the job runs thrice successfully .the avg_fragmentation is the still the same.How can i solve this?

    Thanks

    checking your stats will get you the most mileage

    +1000 to that.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)