SQL Server 2008 Database Engine Tuning Advisor
Posted on 2014-02-12
I regularly use the Database Engine Tuning Advisor to determine what index changes should be made to our SQL Server 2008 database. I usually add whatever indexes it recommends but lately, along with index additions, it lists indexes that should be dropped. I must say I'm a little hesitant to start dropping indexes.
Should I follow the recommendations or is there a better tool to use. I'm a programmer reluctantly performing dba duties and am in need of advice.