Autogenerate Code for Missing Indexes


This MSDN article shows how to use the 'missing index' details and columns available in SQL server.

By simply running the query in the Example, Sql Server actual suggests eventually missing indexes , as well as the details of the Table Name, and the columns to Include.

The task is: after running this query, create a script that generate the code for the missing index.


jondd wrote Jun 22, 2016 at 9:07 PM

I'll pick this one up

vijayrhj wrote Nov 26, 2016 at 4:08 PM

I would like to pick this task.