ROUND(SUM(ps.used_page_count) * 8.0 / 1024, 2) AS index_size_mb -- Calculate index size in MB FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') ips JOIN sys.indexes i ON ...