Welcome to MSDN Blogs Sign in | Join | Help

Parallel Query Execution Presentation

For those of you readers who've been wondering whatever happened to me, I've been rather busy.  Among other activities, I've been writing a chapter for Kalen Delaney's upcoming fourth book in the Inside SQL Server 2005 series: Query Tuning and Optimization.

I am hoping to resurrect my blog and to get things started, I'm posting a presentation that I recently delivered to the Pacific Northwest SQL Server User's Group.  Several attendees asked whether they could have copies of this presentation, so here it is.

Published Tuesday, April 17, 2007 3:47 PM by craigfr
Filed under:

Attachment(s): Parallel Query Execution.pdf

Comments

# re: Parallel Query Execution Presentation

The Non-Parallelizable “Stuff” slide in the attached presentation contained a somewhat ambiguous statement that "TSQL UDFs and CLR UDFs with data access" force a serial plan.  This statement made it sound like TSQL UDFs without data access are compatible with parallel plans.  In fact, ALL TSQL UDFs force serial plans.  CLR UDFs with data access force serial plans.  CLR UDFs without data access are compatible with parallel plans.  I apologize for any confusion and I've updated the slide deck to make it clearer.

Wednesday, May 16, 2007 7:48 PM by craigfr
Anonymous comments are disabled
 
Page view tracker