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 » Internals » Performance » Query Plans   (RSS)
  • Mastering Execution Plan Analysis - Lisbon, Portugal 15 May 2015

    I will be presenting a full day workshop, “Mastering Execution Plan Analysis” on Friday 15 May 2015 as part of SQL Saturday #369 in Lisbon, Portugal. Early-bird tickets are priced at just €135 and are available until 28 February 2015, when the price increases to the regular rate of €150. Tickets can be purchased via EventBrite (where the full ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on January 13, 2015
  • Parallel Execution Plans Suck

    Summary: A deep dive into SQL Server parallelism, and a potential performance problem with parallel plans that use TOP. There was an interesting question asked by Mark Storey-Smith on dba.stackexchange.com back in October 2011.  He was looking at the execution plan for a query that counts a million rows from a virtual auxiliary table of ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on May 2, 2012
  • Join Performance, Implicit Conversions, and Residuals

    You probably already know that it’s important to be aware of data types when writing queries, and that implicit conversions between types can lead to poor query performance.  Some people have gone so far as to write scripts to search the plan cache for CONVERT_IMPLICIT elements, and others routinely inspect plans for that type of thing when ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on July 18, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement