Jonathan Lewis Execution Plans Part 6: Pushed Subqueries In part 5 of this series we examined a couple of examples where you had to handle the “first child first” rule with a little... 16 June 2014 10 min read
Jonathan Lewis Execution Plans part 5: First Child Variations I’ve offered up “first child first, recursive descent” as a basic strategy for interpreting execution plans – but it’s not a perfect rule, and it... 28 May 2014 14 min read
Kat Hicks Diagnosing Common Database Ails When a database starts showing signs of an illness, it's up to the DBA to get to the root of the problem, fast. Kat Hicks... 25 March 2013 13 min read
Robert Sheldon Subqueries in SQL Server Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse when their effect on performance... 26 May 2011 16 min read
