SELECT index_depth AS DEPTH,
index_level AS LEVEL,
record_count AS ROWS,
page_count AS Pages,
avg_page_space_used_in_percent AS PagePercentFull,
min_record_size_in_bytes AS MinLen,
max_record_size_in_bytes AS MaxLen,
avg_record_size_in_bytes AS AvgLen
FROM sys.dm_db_index_physical_stats(DB_ID(), OBJECT_ID('tTrans.TransDeed'), 1, 1, /*'LIMITED'*/'DETAILED') ; ----Limited
GO