Browse by Tags

• Internals
• Parallelism
• Statistics

• Forcing a Parallel Query Execution Plan

  This post is for SQL Server developers who have experienced the special kind of frustration, which only comes from spending hours trying to convince the query optimizer to generate a parallel execution plan.  This situation often occurs when making Read More... Posted Friday, December 23, 2011 10:09 AM by Paul White | 59 Comments Filed under: Internals, Parallelism, Query Optimizer, Query Plans, Trace Flags, Undocumented

• How to Find the Statistics Used to Compile an Execution Plan

  In this post, I show you how to determine exactly which statistics objects were used by the query optimizer to produce an execution plan. Trace Flags We will need three undocumented trace flags.  The first one ( 3604 ) is well-known – it redirects Read More... Posted Wednesday, September 21, 2011 5:22 AM by Paul White | 21 Comments Filed under: Query Optimizer, Query Plans, Statistics, Trace Flags, Undocumented