If you've managed database performance, you've come across the wait types CXPACKET and CXCONSUMER. You've seen a lot of conflicting instructions on how to go about fixing them, and you know that setting MAXDOP to 1 isn't the right thing to do.
Learn what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and what you can do about it.
Palestrantes
Brent Ozar, Microsoft Certified Master