Home Forums SQL Server 2008 SQL Server 2008 - General Fragmentation accuracy? 98% fragmented?!! RE: Fragmentation accuracy? 98% fragmented?!!
Lynn Pettis
SSC Guru
Points: 442467
More actions
May 26, 2013 at 11:27 am
#1618595
The table is a heap (no clustered index). The index_id will be a 0 (zero). You may want to add this column to the query also: ps.forwarded_record_count.