• Here is a good article from SSC on MAXDOP

    http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/