Overlapping Stats and Unicorns

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"

Statistics Parser

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"