Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution. Determine whether the solution meets stated goals.You manage a Microsoft SQL Server environment with several databases.
You need to ensure that queries use statistical data and do not initialize values for local variables.
Solution: You enable the QUERY_OPTIMIZER_HOTFIXES option for the databases.
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
QUERY_OPTIMIZER_HOTFIXES = { ON | OFF | PRIMARY } enables or disables query optimization hotfixes
regardless of the compatibility level of the database. This is equivalent to Trace Flag 4199.
https://msdn.microsoft.com/en-us/library/mt629158.aspx