sp_QuickieStore - New parameter that allow to only show queries with Query Hints (2022+)
ClaudioESSilva opened this issue · 1 comments
Is your feature request related to a problem? Please describe.
No.
Describe the solution you'd like
Support a new parameter (example: @only_query_with_hints
) that only retrieves queries with any Query Hint applied.
Within sp_QuickieStore
when this parameter is used @only_query_with_hints = 1
it will filter by queries with entries on the sys.query_store_query_hints
.
The suggested output when that parameter is 1 is the main one plus the content of the sys.query_store_query_hints
.
When @only_query_with_hints = 0
(default) we get the regular output:
With both @expert_mode = 1
and @only_query_with_hints = 1
:
Describe alternatives you've considered
Having a custom script to grab the same thing. But I use sp_QuickieStore
a lot so, having this built-in would be a win-win
Are you ready to build the code for the feature?
Yes. I will submit a PR with the code changes for review.
Closed via #366