I agree, it is no substitute for hard work, ie. review, research and familiarity with the environment. While it may recommend "too many" or duplicate indexes it also may recommended...

TheSQLGuru -How about some examples of these "amazingly bad things" you say the tuning advisor has done to databases? I've used it a couple of times with great results....

That is easy, thanks! Both methods still strike me as kind of an odd approach. I'll try that the next time I have the need.

Pablo -

I updated the owner through the system table, sysdtspackages90, which is not the best way to approach the problem. I'm a little dismayed that the system table holding...

I look forward to more...thanks!