CODEWITHSUNDEEP
sql-serversql-server-2005
Ali Tarhini
Ali Tarhini

Reputation: 5358

how to run a parallel query on sql server 2008?

i want to run a query on multiple processors. what is the syntax to run a parallel query? please provide a sample query

Upvotes: 2

Views: 5479

Answers (1)

gbn
gbn

Reputation: 432230

You don't: the optimizer decides based on the "cost" of the query (and some other factors)

See BOL: Parallel Query Processing

Now, you can limit parallelism with MAXDOP or change the cost threshold, but it's not something I'd do.

Why do you want to explicitly set this?

Upvotes: 4

Related Questions