erikdarlingdata/DarlingData

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.

image

When @only_query_with_hints = 0 (default) we get the regular output:
image

With @expert_mode = 1:
image

With both @expert_mode = 1 and @only_query_with_hints = 1:
image

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