I have generated missing index for all my servers and below is the suggestion from SQL server DMV and I have put that in a table . Below is just two columns out of few columns. As you can see below in index_columns which I have highlighted in yellow there is two same camp_id for instance name DB02 as index key column
My question : Since I have many servers instance and its taking time to do manually, does anyone knows how to write a query to check index_columns rows if there is redundant index key columns (like camp_id) based on the instance name column.
Below screenshot it's just got two instance name but actually I have many instance
Appreciate your help