DBCC SHOWCONTIG is deprecated

DBCC SHOWCONTIG is no longer the supported way of investigating index fragmentation.

DBCC SHOWCONTIG only displays the first partition of the specified table or index and does not display row-overflow storage information or spatial indexes. It does not show  off-row data types, such as NVARCHAR(MAX), VARCHAR(MAX), VARBINARY(MAX), and XML.

Use sys.dm_db_index_physical_stats instead.

Didn't find what you were looking for?