I ran across a thread about statistics being up to date and part of it was about stats generated by DTA (see the comment by Aaron Bertrand). Easy to identify: select db_name() as dbname, name from sys.stats where name like ‘_dta_stat%’ Are they being used? Drop them? Assuming autostats is on, the only risk would […]

Read more "Stats Generated By Database Tuning Advisor"