More than half of the times I’m asked to troubleshoot performance issues on MS-SQL I end up finding a missing index as the cause of the problem.

I’m sure that as part of the initial database design process the most important indexes are created, but  as the application evolves new queries are introduced and verifying if there is an index backing up the new query is usually an afterthought.