PrepAway - Latest Free Exam Questions & Answers

Which option should you use?

You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports.
You need to force a query to use only one processor core without affecting other queries.
Which option should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
OPTION (FAST 1)

B.
OPTION (MAXDOP 1)

C.
OPTION (RECOMPILE)

D.
OPTION (MAXRECURSION 1)


Leave a Reply