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 (17 total posts)
  • 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 an apparently innocuous change to the text of a moderately complex query; a change which ...
    Posted to Page Free Space (Weblog) by Paul White on December 22, 2011
  • 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
  • SQL Server 2008 R2 still requires a trace flag for Lock Pages in Memory

    Almost two years ago, I blogged that Lock Pages in Memory was finally available to Standard Edition customers (Enterprise Edition customers had long been deemed smart enough to not abuse this feature).  In addition to applying a cumulative update (2005 SP3 CU4 or 2008 SP1 CU2), in order to take advantage of LPIM, you also had to enable trace ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 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
  • SQL Server challenge: show me trace flag 1118 is significant -- a quick update

    I posted the following SQL Server challenge yesterday:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   In response, Konstantin Korobkov wanted to know whether the number of data files in tempdb would make a difference.   I did test that scenario and did ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 2, 2009
  • SQL Server challenge: show me trace flag 1118 is significant

    Here is a SQL Server challenge as I have failed so far:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   I have seen a lot of chatters, anecdotes, and stories on the impact of trace flag 1118 on reducing tempdb contentions. But I have not seen ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 1, 2009
  • Big News : Lock Pages in Memory for Standard Edition

    After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki), Microsoft's Bob Ward just announced at the European PASS Conference that they are going to allow the 'lock pages in memory' privilege for all the lowly peons running Standard Edition.  Currently this has only been allowed on Enterprise ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 24, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement