SQL Server - Create Indexes from the Missing Indexes DMV

home
database
view story

3 Kicks

SQL Server - Create Indexes from the Missing Indexes DMV(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 11 months ago

Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular I found extremely helpful in fixing some of the issues in my system. I took his query (the CTE at the top) and added some text manipulation to actually generate the create statements for you to save you some time. I had much grander plans for this, but unfortunately I’ve been meaning to post this for over a month now and simply haven’t had time to get back to it, so rather than just let it go by the wayside and never post it, I figured I’d just post what I had now and then possibly post an update sometime in the future if I ever finish it.

add a comment |category: Database |Views: 12
Tweet