THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Trace Flags   (RSS)
Showing page 2 of 2 (12 total posts)
  • 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 trace output to the client so it appears in the SSMS messages tab. The second trace flag is ...
    Posted to Page Free Space (Weblog) by Paul White on September 20, 2011
  • Inside the Optimizer: Constructing a Plan – Part 4

    Summary: More undocumented ways to explore how the query optimiser works. This post is part of a series: Part1 Part 2 Part3 Part4 Documented Rule-Affecting Options It might surprise you to learn that most T-SQL users have written queries that disable one or more of the optimiser rules already. Join hints { LOOP | HASH | MERGE | ...
    Posted to Page Free Space (Weblog) by Paul White on July 31, 2010
Privacy Statement