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.