RE: Taking Advantage of SQL Server Tools

SSC Guru

Points: 107049

March 6, 2010 at 4:44 pm

I'm not sure if Database Engine Tuning Advisor should be on that list:

I think DTA sometimes (mostly?) is misguiding in terms of indexing. I'd rather study execution plans or use some scripts to find missing/unused indexes.

When DTA is used to optimize design structure then I think there is something wrong in general, not only related to SQL Server...

I'm not sure how helpful DTA would be in terms of partitioning, since I never tried.

I agree with the remaining list though. Even if BIDS and myself aren't friends yet.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]