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 […]
statistics
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 […]