Can anyone point me in the direction of a Microsoft Tool or menu option inside SQL Server 2005 that displays all the "missing" indexes that I should add to make the system perform at optimal levels?
I'm assuming that to avoid full table scans that _every_ query column-combination that is ACTUALLY USED by my code over the course of a day should have an index created, right?
Over the course of the day I'd like to run a report that says:
In the last 24 hours you're missed these indexes:
It would be even cooler if you could press a button that says "Create these indexes now?"
Wouldn't this avoid hours of research?
Does Microsoft offer such a thing? If not, what do folks do to make sure they don't miss any indexes?