Post reply

Table Rows deleted but not shrinking in size

  • September 17, 2019 at 10:47 pm

    #3680883

    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.

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

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