Undo changes made by SQL Server Database Tuning

Question

I am not sure if this question can be asked here or serverfault. I was wondering...Is there is a way to quickly undo the changes made by SQL Server 2005 Tuning Advsor other than recovering from a backup?

Answer 1

There is a way as long as you haven't renamed them usually Database Tuning Advisor generated objects are prefixed with _dta

so you can view them by running this query

FOR indexes

SELECT        
*
FROM            
sys.indexes where name like '_dta%'

FROM Stats

SELECT
*
FROM 
sys.stats where name like '_dta%'

And from there I guess you would know what items to drop