• For a little extra fun, you can even see that ghost records are being retained because of snapshot isolation if you run sys.dm_db_index_physical_stats using DETAILED mode. There's a handy column in the results just for that purpose, version_ghost_record_count.

    Cheers!