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.
is pronounced "ree-bar
" and is a "Modenism
" for R
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."
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)