摘要：
SELECT databases.name , objects.name , indexes.name , 读写比例 = CAST(( range_scan_count + singleton_lookup_count ) AS DECIMAL(18, 2)) / CASE WHEN CAST(( leaf_insert_count + leaf_update_count + leaf_delete_count + nonleaf_insert_count + nonleaf_update_count + nonleaf_delete_count ) AS DECIMAL(18, 2)) = 阅读全文
摘要：
SELECT objects.name , indexes.name AS indexid , avg_fragmentation_in_percent AS frag , partition_stats.row_count, 'ALTER INDEX '+indexes.name+' ON '+objects.name+' REBUILD WITH (ONLINE = ON )'FROM sys.dm_db_index_physical_stats(7, NULL, NULL, NULL, 'LIMITED') stats LE 阅读全文
