how can i choose MAX DEGREE OF PARALLISM for SQL SERVER 2008?
View Complete Post
I have a query used to load a target table but it is not using parallelism. The SELECT is loading 15M rows. How can I influence (change the query) the optimizer to use it?
A similar query pulling from a separate DB but same tables is utilizing parallelism. This query load 150M rows.