Database Tuning Advisor vs. using your own good judgement
Posted on 2013-11-01
I am trying to debate whether to use the Database Tuning Advisor in SQL Studio vs. just picking columns that need to be indexed in my table. Is there really an advantage to using the Database Tuning Advisor.
Also, how does it work? Do I just run an aggressive script and then apply the recommendations afterwards?