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"