PrepAway - Latest Free Exam Questions & Answers

which sp_configure configuration option should you set?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which has to be configured to use a single thread for queries. The queries have an estimated execution cost less than 3. So which sp_configure configuration option should you set?

PrepAway - Latest Free Exam Questions & Answers

A.
You should set priority boost

B.
You should set precompute rank

C.
You should set max worker threads

D.
You should set query governor cost limit

E.
You should set cost threshold for parallelism


Leave a Reply