"Query Store Hints: Fixing SQL You Cannot Edit"

1. What is the primary purpose of Query Store hints in SQL Server?

To modify the query text directly To attach a hint to a query identified by its query_id To create new stored procedures To generate dynamic SQL queries

2. Which command is used to apply a hint to a query in the Query Store?

EXEC sys.sp_query_store_get_hints EXEC sys.sp_query_store_clear_hints EXEC sys.sp_query_store_set_hints EXEC sys.sp_query_store_apply_hints

3. Why are Query Store hints preferred over plan guides in SQL Server?

They execute faster They are easier to create and maintain They require exact text matching They cannot be cleared once applied

4. What happens to a hint if the text of the query changes?

The hint is automatically updated The hint remains but is attached to the old query_id The hint is removed The hint converts to a plan guide

Continue: "Reporting Is a Different Workload" → Review this lesson Retake quiz