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 » parallelism » Query Plans   (RSS)
  • SQL Intersection Conference, Las Vegas MGM Grand 10-13 November 2014

    I am very pleased to announce that I will be speaking at the SQL Intersection conference in Las Vegas again this year. This time around, I am giving a full-day workshop, "Mastering SQL Server Execution Plan Analysis" as well as a two-part session, "Parallel Query Execution" during the main conference. The workshop is a ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on July 31, 2014
  • 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
  • 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 Paul White: Page Free Space (Weblog) by Paul White on December 22, 2011
  • Myth: SQL Server Caches a Serial Plan with every Parallel Plan

    Many people believe that whenever SQL Server creates an execution plan that uses parallelism, an alternative serial plan is also cached.  The idea seems to be that the execution engine then decides between the parallel and serial alternatives at runtime. I’ve seen this on forums, in blogs, and even in books.  In fairness, a lot of the ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on November 4, 2010
  • PASS Performance Virtual Chapter: Parallelize Your Queries!

    Last month a new PASS Virtual Chapter was introduced, one with a theme that is near and dear to much of what I like to work on: performance. Tomorrow, Tuesday August 3rd at noon Eastern time, the chapter will have its second meeting, and I will be doing the presentation. The topic is Parallelism and Performance. Here's the abstract:In ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 2, 2010
  • SQL University: Parallelism Week - Part 2, Query Processing

    Welcome back for the second part of Parallelism Week here at SQL University. Get your pencils ready, and make sure to raise your hand if you have a question. Last time we covered the necessary background material to help you understand how the SQL Server Operating System schedules its many active threads, and the differences between its ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 26, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement