Table Rows deleted but not shrinking in size

  • Jeff Moden

    SSC Guru

    Points: 996030

    The article recommends doing a cume on the "ghost_record_count" of sys.dm_db_index_physical_stats.  It shows no ghost records, which is what I expected because of the very low page counts for the indexes compared to the "unused" pages using sp_spaceused.

    In another search, this appears to be common problem for WhatsUp Gold.  Some claim that it's because of retention settings but that doesn't seem to be the case here.

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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)

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply