Hi - I've got a server with 8 CPUs and I've been advised to change the MAXDOP setting. I understand the default is MAXDOP=0. MSDN suggest the following: set MAXDOP=8 if I have 8 CPUs. Will changing this from MAXDOP=0 to MAXDOP=8 improve performance? If so how, as Microsoft have verbally recommended this but I can't see anywhere where it is documented as a performance improvement?