Adam Machanic : query processing, maximum degree of parallelismhttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/query+processing/maximum+degree+of+parallelism/default.aspxTags: query processing, maximum degree of parallelismenCommunityServer 2.1 SP2 (Build: 61129.1)SQL University: Parallelism Week - Part 3, Settings and Optionshttp://www2.sqlblog.com/blogs/adam_machanic/archive/2010/05/28/sql-university-parallelism-week-part-3-settings-and-options.aspxFri, 28 May 2010 12:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:25485Adam Machanic6http://www2.sqlblog.com/blogs/adam_machanic/comments/25485.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=25485Congratulations! You've made it back for the the third and final installment of Parallelism Week here at SQL University . So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how parallel query plans actually work...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/05/28/sql-university-parallelism-week-part-3-settings-and-options.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=25485" width="1" height="1">query processingparallelismSQL Universityparallel processingmaximum degree of parallelismcost threshold for parallelismmaxdop