Uwe Ricken When AUTO_UPDATE_STATISTICS Doesn’t Happen When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the... 07 March 2016 10 min read
Dennes Torres Checking the Plan Cache Warnings for a SQL Server Database How often do you check your query plans during development to see if they contain any warnings? If you're missing... 11 February 2015 10 min read
Fabiano Amorim Join Reordering and Bushy Plans Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from... 05 March 2013 17 min read
Fabiano Amorim Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware.... 30 January 2013 9 min read
Grant Fritchey Statistics in SQL Server SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or... 08 January 2013 10 min read
Joe Sack Fixing Gatekeeper Row Cardinality Estimate Issues The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator... 01 November 2012 18 min read
Database Administration Fabiano Amorim in Database Administration Statistics on Ascending Columns It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an... 01 September 2011 10 min read
Fabiano Amorim Questions about SQL Server Distribution Statistics Fabiano was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current... 23 June 2011 20 min read
Fabiano Amorim Showplan Operator of the Week – Merge Interval When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting... 11 January 2011 7 min read
Fabiano Amorim ShowPlan Operator of the Week – Merge Join Did you ever wonder how and why your indexes affect the performance of joins? Once you've read Fabiano's unforgettable explanation,... 22 November 2010 9 min read
Holger Schmeling SQL Server Statistics: Problems and Solutions SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common... 27 October 2010 39 min read
Fabiano Amorim Showplan Operator of the Week – Stream Aggregate Fabiano continues his mission to explain the Query Optimiser in practical terms, describing, one week at a time, all the... 10 September 2010 9 min read
Fabiano Amorim Operator of the Week – Spools, Eager Spool For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he... 20 May 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – BookMark/Key Lookup Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he... 07 May 2010 7 min read
Fabiano Amorim Showplan Operator of the Week – Compute Scalar The third part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser continues with... 28 April 2010 6 min read
Fabiano Amorim Showplan Operator of the Week – Concatenation Fabiano continues in his mission to describe, one week at a time, all the major Showplan Operators used by SQL... 22 April 2010 3 min read
Fabiano Amorim Showplan Operator of the week – Assert As part of his mission to explain the Query Optimiser in practical terms, Fabiano attempts the feat of describing, one... 14 April 2010 7 min read
Fabiano Amorim 13 Things You Should Know About Statistics and the Query Optimizer Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a... 07 January 2010 24 min read
Grant Fritchey Controlling Execution Plans with Hints The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best... 12 November 2009 38 min read
