1
Vote

Autogenerate Code for Missing Indexes

description

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.

comments

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.