DECLARE @IX TABLE(index_handle INT,eq NVARCHAR(4000),included_columns NVARCHAR(4000),NAME VARCHAR(100),dbname VARCHAR(30))
;WITH idx AS(
SELECT a.index_handle ,a.equality_columns,a.inequality_columns,a.equality_columns+CASE WHEN a.inequality_columns IS NULL THEN '' ELSE ','+a.inequality_columns END AS eq ,a.included_columns,b.name,c.name dbname
FROM sys.[dm_db_missing_index_details] a
INNER JOIN sysobjects b ON a.object_id=b.id
INNER JOIN Master..SysDatabases c ON c.dbid=a.database_id
WHERE a.equality_columns>''
UNION ALL
SELECT a.index_handle ,a.equality_columns,a.inequality_columns,CASE WHEN a.inequality_columns IS NULL THEN '' ELSE a.inequality_columns END AS eq ,a.included_columns,b.name,c.name dbname
FROM sys.[dm_db_missing_index_details] a
INNER JOIN sysobjects b ON a.object_id=b.id --默认当前的数据库
INNER JOIN Master..SysD