摘要: Use [数据库名称] Go DECLARE @DBCCString NVARCHAR(1000) DECLARE @TableName VARCHAR(100) DECLARE Cur_Index CURSOR FOR SELECT Name AS TblName FROM sysobjects WHERE xType='U' ORDER BY TblName FOR READ ONLY OPE 阅读全文
posted @ 2019-09-03 16:00 农村手艺人 阅读(796) 评论(0) 推荐(1) 编辑
摘要: SELECT * FROM sys.[dm_db_missing_index_details] SELECT * FROM sys.[dm_db_missing_index_groups] SELECT * FROM sys.[dm_db_missing_index_group_stats] SELECT * FROM sys.[dm_db_missing_index_columns](1) -- 阅读全文
posted @ 2019-09-03 15:29 农村手艺人 阅读(368) 评论(0) 推荐(0) 编辑