troubleshootingsql.com
How to find out the missing indexes on a SQL Server 2008 or 2005 instance along with the CREATE INDEX commands
I had previously blogged on Missing Indexes and how useful a feature this is for troubleshooting query performance issues. Here is a script for identifying the missing indexes currently on your ins…