PrepAway - Latest Free Exam Questions & Answers

Which sp_configure configuration option should you set?

You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated
execution cost less than 3.
Which sp_configure configuration option should you set?

PrepAway - Latest Free Exam Questions & Answers

A.
priority boost

B.
precompute rank

C.
max worker threads

D.
query governor cost limit

E.
cost threshold for parallelism


Leave a Reply