Home Forums SQL Server 2008 SQL Server 2008 Administration Fragmentation size RE: Fragmentation size

  • December 30, 2012 at 11:26 pm

    #1572430

    zi (12/30/2012)

    Thanks for replying

    Do you have a script to know the fragmentation size for the whole database not only table by table.

    Thanks lot

    You don't need one. Just check the file fragmentation report of your favorite disk defragmentation tool for the file name(s) of the given database.

    --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)