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