Per-query Parallelism Level
An explicit parallelism level can be set for a single query. to test its effect. Use the following syntax:
SELECT...WITH MAX_PARALLEL n
where n is an integer between 1 and 256. The value of n should not exceed the number of CPU cores visible to the operating system.