Decoded Statistics Names and More

Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we can decode those names and reveal what the names really mean. 

Linked Servers and Stats

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers.

SQL Statistics – another Spin

I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for the entire database. ¬†While reading the blog, I was reminded about an interesting tidbit of […]