Many, many times I discuss with SharePoint SQL people this issue of Max Degree of Parallelism or MAXDOP. http://technet.microsoft.com/en-us/library/cc298801.aspx#Section6_3 states pretty clearly, that "To ensure optimal performance, we strongly recommend that you set max degree of parallelism ...