You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to set the instance to utilize one
thread for searches which owns an estimated execution cost less than 2.
What should you do?
A.
You should consider setting the cost threshold for parallelism.
B.
You should consider setting the DBCC SHRINKFILE.
C.
You should consider setting the DBCC INDEXDEFRAG.
D.
You should consider setting the store procedure.
E.
You should consider running a Transact-SQL statement.