Select OBJECT_ID (' dbo. Ft_cfp_trade_subaccount ')
SELECT * from sys.partitions where [object_id]=1467256382
SELECT * from Sys.allocation_units where container_id=72057594139049984
SELECT * FROM sys.system_internals_allocation_units where container_id=72057594139049984
SELECT * from Sys.dm_db_index_physical_stats (db_id (), object_id (' dbo. Mm_realquotehistory_11 '), Null,null, ' sampled ')
SELECT * from Sys.dm_db_index_physical_stats (db_id (), object_id (' dbo. Mm_realquotehistory_11 '), Null,null, ' detailed ')
SELECT object_name (a.object_id) [TableName], a.index_id, name [IndexName], avg_fragmentation_in_percent,
a.*,b.*
From Sys.dm_db_index_physical_stats (db_id (), NULL, NULL, NULL, NULL) as a
JOIN sys.indexes as B on a.object_id = b.object_id and a.index_id = b.index_id
DBCC SHOWCONTIG (' dbo. Mm_realquotehistory_11 ')
SQL Server index parsing related sql