Skip to content

March 1 2026 release (v2)#687

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

March 1 2026 release (v2)#687
erikdarlingdata merged 4 commits intomainfrom
dev

Conversation

@erikdarlingdata
Copy link
Copy Markdown
Owner

Summary

  • Includes feature/661-automatic-tuning that was missed in the first merge

🤖 Generated with Claude Code

erikdarlingdata and others added 4 commits February 13, 2026 00:31
Issue #661:

Add sys.database_automatic_tuning_configurations to sp_QuickieStore expert mode

4 changes to sp_QuickieStore.sql:

1. Temp table (line ~1483): #database_automatic_tuning_configurations with correct data types (notably sql_variant
  column type_value is stored as nvarchar(120) with explicit CONVERT, and state is integer — the Microsoft docs were
  wrong about the types)
  2. Data population (line ~8552): Inside IF @sql_2022_views = 1, queries sys.database_automatic_tuning_configurations
  with no WHERE filter (database-level config, not per-query)
  3. Expert mode output (line ~9364): Shows the result set when @expert_mode = 1 and data exists. Silently skips when
  empty (empty is normal)
  4. Debug output (line ~11715): Standard debug pattern with "is empty" message

Tested and working on both sql2022 (16.0.4222) and sql2025 (17.0.4015) — the initial sp_configure_automatic_tuning
  failure on sql2022 was bad parameter syntax, not a version limitation. The feature works identically on both versions.
Avoids implicit nvarchar-to-bigint conversion; TRY_CAST works at all
compat levels unlike TRY_CONVERT which requires >= 130.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
…ning

sp_QuickieStore: add sys.database_automatic_tuning_configurations support
@erikdarlingdata erikdarlingdata merged commit f999f02 into main Mar 2, 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.

2 participants