WHEN ips.avg_fragmentation_in_percent > 30 THEN 'REBUILD' WHEN ips.avg_fragmentation_in_percent > 10 THEN 'REORGANIZE' ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results