You might want to try the free trial of Qure Optimizer, a workload tuning solution by DBSophic. I have seen quite a few cases where users didn't get what they...
There are several free tools you can use to analyze your trace files and quickly identify problematic queries. One of the popular ones is Qure Analyzer, available here:
Actually, here's a free tool I use for troubleshooting a wide range of query-related problems (by I/O, by CPU, by User, by multiple dimensions... whatever).
Thanks for very clear overview of indexing considerations. A related topic that is sometimes overlook is the challenge of predicting the effects of an individual index on the workload as...