How Multi-Column Statistics Work
The short answer: in the real world, only the first column works. When SQL Server needs data about […]
statistics
Automatic Stats Updates Don’t Always Invalidate Cached Plans
Normally, when SQL Server updates statistics on an object, it invalidates the cached plans that rely on that […]
Functions in the WHERE Clause Are Bad… Right?
Nah, not necessarily. SQL Server’s query optimizer behavior keeps changing with every freakin’ version. Let’s illustrate it with […]
Free Video Training: Estimation and Statistics by Dave Ballantyne
It’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s […]