Fun for the day – Automated Auto-Indexing!

We’ve been hard at work up here on a little prototype for you guys to try.  This attachment is a basic automatic indexing solution built on top of SQL Server 2005 using the Missing Index DMVs that we discussed in our previous blog post: http://blogs.msdn.com/queryoptteam/archive/2006/04/06/570176.aspx Effectively, this will periodically determine top index candidates for your workload. …

13