• Jessie, thanks very much for this, but I found something rather interesting, perhaps you can explain.

    The query identified a table with row count = 154 and phys_size_KB = 26760. However, when I selected all rows I got a count of 202 is this because the statistics are out of date?

    This table has a high unused allocation of 99%. I calculated this based on unused/reserved. I just ran a shrink on the database and it does not seem to help. Can you explain this?

    Thanks


    Doug