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
Fabiano Amorim Showplan Operator of the Week – SORT Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the... 11 October 2010 5 min read
Fabiano Amorim Showplan Operator of the Week – Row Count Spool The Row Count Spool operator is a simple component in an execution plan that can make an enormous difference to... 06 July 2010 5 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
