Sliding Scale Parallelism: Why Stop At DOP?

Erik Darling wonders why SQL Server doesn't have more granular parallelism options.

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.

Maximum degree of Parallelism

Understanding and Using Parallelism in SQL Server

SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and how you can be sure that it is doing so, isn't entirely obvious to most of us. Paul White begins a series that makes it all seem simple, starting at the gentle level of counting Jelly Beans.

Configuring the Maximum Degree of Parallelism

How to configure settings to limit the number of processors used in parallel query execution