The ins and outs of MAXDOP
Configuring MAXDOP One of the few sp_configure options that good DBAs regularly change is “max degree of parallelism” or MAXDOP. So of course everyone is looking for the one best value to use for that setting.
Read the original post:
The ins and outs of MAXDOP


