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   (RSS)
Showing page 1 of 2 (14 total posts)
  • 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 Page Free Space (Weblog) by Paul White on July 31, 2014
  • Geek City: A Hint of Degrees

    This is just a quick post to describe a test I just ran to satisfy my own curiosity. I remember when Microsoft first introduced the query hint OPTION (MAXDOP N). We already had the configuration option ‘max degree of parallelism’, so there were lots of questions about how the hint interacted with the configuration option. Some people thought the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 3, 2014
  • Did You Know? What settings to always change

      A week ago, I taught my SQL Server 2012 Internals class to a great group of very interactive students. Even though a dozen of them were taking the class remotely, there were still lots of really great questions and and lots of discussion. One of the students asked if I could summarize all the settings that I recommended changing from the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 25, 2013
  • 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 Page Free Space (Weblog) by Paul White on May 2, 2012
  • Connect Digest : 2012-03-06

    This time around, I've got five wish list items for T-SQL / DDL, and then one bonus - a parallelism bug. My thinking on the former is that, since we are either about to start (or are just finishing) locking down the code for SQL Server 2012, this is the first moment where some of these suggestions can be seriously considered without the ''but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 6, 2012
  • Connect Digest : 2012-01-09

    Hide databases from users who shouldn't be able to see them This is a long-standing request from Erland Sommarskog which I've highlighted in previous digests. But the underlying problem keeps coming up in multiple venues, so I thought it would be good to call attention to the item one more time. Some will argue that the contained database feature ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 9, 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 Page Free Space (Weblog) by Paul White on December 22, 2011
  • Connect Digest : 2011-05-23

    Next week I'll be up in Alaska for SQL Cruise, so I'll be skipping at least one digest. This week I gathered a few engine-related issues, two involving what the engine does while an index is being created. The most important one, though, at least IMHO, is the first one listed, involving a hashing algorithm fix that is in SQL Server 2008 R2 - but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 23, 2011
  • How Parallelism Works in SQL Server

    You might have noticed that January was a quiet blogging month for me.  Part of the reason was that I was working on a series of articles for Simple Talk, examining how parallel query execution really works.  The first part is published today ...
    Posted to Page Free Space (Weblog) by Paul White on March 5, 2011
  • SQL Sentry Plan Explorer : Version 1.1!

    Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL Sentry Plan Explorer 1.1 (build 6.0.67.0). So, what's new?  Several wish list items have been fulfilled (hey, it is Christmas, after ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 22, 2010
1 2 Next >
Privacy Statement