SELECT o.name as tablename,s.* FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) s,sys.objects o where o.object_id =s.object_id order by avg_fragment_size_in_pages desc
SELECT o.name as tablename,s.* FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) s,sys.objects o where o.object_id =s.object_id order by avg_fragment_size_in_pages desc
TSQL 查询重复列 (2024-7-16 1:31:38)
SQL Server数据库优化、收缩数据库 (2024-7-16 1:29:38)
设置SQL Server只能看自己的数据库 (2024-7-16 1:28:45)