Skip to content

sp_QuickieStore: @find_high_impact output fixes#700

Merged
erikdarlingdata merged 2 commits intomainfrom
dev
Mar 23, 2026
Merged

sp_QuickieStore: @find_high_impact output fixes#700
erikdarlingdata merged 2 commits intomainfrom
dev

Conversation

@erikdarlingdata
Copy link
Copy Markdown
Owner

Summary

Post-release fix for @find_high_impact output:

  • query_sql_text uses processing-instruction XML pattern (clickable in SSMS)
  • top_waits column omitted when Query Store wait stats unavailable

Tested on SQL2022 and SQL2016.

🤖 Generated with Claude Code

erikdarlingdata and others added 2 commits March 23, 2026 14:53
- query_sql_text now uses processing-instruction XML pattern (clickable
  in SSMS without encoding issues), matching the main output path
- top_waits column and LEFT JOIN conditionally omitted when Query Store
  wait stats are unavailable (SQL 2016 or waits not enabled) instead of
  showing a NULL column
- Updated help text to reflect conditional top_waits behavior

Tested on SQL2022 (waits present) and SQL2016 (waits omitted).

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
…-fixes

sp_QuickieStore: fix @find_high_impact output formatting
@erikdarlingdata erikdarlingdata merged commit c996931 into main Mar 23, 2026
9 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant