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"A while back I was doing some routine housekeeping and ran a script Kendal Van Dyke wrote to identify duplicate statistics. Not uncommon for those to occur, queries get written that need a stat and the system creates one, later someone does some tuning and adds an index which then creates another stat. The space […]
Read more "Overlapping Stats and Unicorns"A quick plug today for Statistics Parser by Richie Rump, a free web site that takes the output from “set statistics io” and formats them (client side) into a tabular format. Interesting and useful to someone who doesn’t have permission to run Profiler (or know how to use it). More interesting because turning on statistics […]
Read more "Statistics Parser"
SQLAndy 