Thanks for the sql.

However, why not going through the next step and return the index details at the same time...

Something like

SELECT TOP 20 mid.statement as table_name, equality_columns, inequality_columns, included_columns

, CAST(index_advantage...

Mark,

My "source" is Itzik Ben-Gan's (highly recommended) "Inside Sql Server 2005: T-Sql Querying" book and he seemed pretty convinced (and convincing).

I'm only repeating... 🙂

Mark,

I read that running profiler was not a good idea, even on a separate box.

I understand you would have been better off "doing it yourself" through the trace stored procedures...

Yes, I was planning to select very few events and columns as well as putting a filter on duration.

I also like the idea of looking for long running queries in...

Jeff,

Thanks for the explanation, and the last query.

Eric

Guys,

Yes, it is 2k5 specific.

Yes it is a correlated sub query but why is this a problem?

Thanks

Eric

Unless you are an "expert" (god knows what this means...) you should be much better off staying away from cursors.

Although it's not exactly easy to read... I still much prefer...