Forcing Parallelism SQLChallenge (48 minutes)

A database administrator has changed Cost Threshold for Parallelism on the instance, and you’ve got a query that’s slowed down.

Your challenge: can you coerce SQL Server into giving the query a parallel plan again, without changing instance wide settings or re-writing the query?

Get the scripts

https://github.com/LitKnd/SQLWorkbooks/tree/main/forcing_parallelism_sqlchallenge

Modules

Menu