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?
While not directly related to Tuning Advisor, this statement by Scott Pletcher may influence the indexing you are about to perform:[Btw, worst performance myth of all time: no matter what some "experts"
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…