You are mastering the company database; you should use the SQL Server 2005 database
which enables business users to operate both ad hoc and predefined searches. Youdoubt
that some searched will cost too many resources. You should clarify which searches cost the
most resources. You decide to finish this aim as quickly as possible. Which is the correct
answer?
A.
You should utilize the sqldiag function
B.
You should utilize the sys.dm_exec_query_stats dynamic management view (DMV).
C.
You should utilize the DBCC INPUTBUFFER requirements
D.
You should utilize the SHOWPLAN session selection.