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 ...
-- Description: Set up the benchmark_frag schema in WH_01 for the fragmentation experiment. -- - Creates schema benchmark_frag (idempotent). -- - Creates store_sales as an EMPTY table (schema cloned ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results