Search results

BUG (P2): @QueryStorePriority OLTP_LIGHT preset dead code — IS NULL gate inert with non-NULL default

bugSomething isn't workingSomething isn't working

code-qualityRefactoring, dead code removal, maintainability, or internal correctnessRefactoring, dead code removal, maintainability, or internal correctness

p2-importantSemantic gap, missing warning, or undocumented behavior that affects correctnessSemantic gap, missing warning, or undocumented behavior that affects correctness

Status: Open.

#335 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

BUG (P2): LastStatCompletedAt heartbeat write failure marks succeeded stat as FAILED

bugSomething isn't workingSomething isn't working

code-qualityRefactoring, dead code removal, maintainability, or internal correctnessRefactoring, dead code removal, maintainability, or internal correctness

p2-importantSemantic gap, missing warning, or undocumented behavior that affects correctnessSemantic gap, missing warning, or undocumented behavior that affects correctness

Status: Open.

#334 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

ENHANCEMENT (P2): @StopByTime can overshoot maintenance window — add budget guard and overshoot warning

enhancementNew feature or requestNew feature or request

p2-importantSemantic gap, missing warning, or undocumented behavior that affects correctnessSemantic gap, missing warning, or undocumented behavior that affects correctness

performanceExecution speed, resource usage, or scalability of the procedure itselfExecution speed, resource usage, or scalability of the procedure itself

Status: Open.

#333 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

ENHANCEMENT (P2): QS forced plan detection should run unconditionally, not gated on @QueryStorePriority

enhancementNew feature or requestNew feature or request

p2-importantSemantic gap, missing warning, or undocumented behavior that affects correctnessSemantic gap, missing warning, or undocumented behavior that affects correctness

query-storeQuery Store integration, forced plans, or QS-related logicQuery Store integration, forced plans, or QS-related logic

Status: Open.

#332 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

ENHANCEMENT (P2): Add ROWLOCK hint to parallel queue MIN subquery

enhancementNew feature or requestNew feature or request

lockingLocking hints, deadlock risk, or row/page lock behaviorLocking hints, deadlock risk, or row/page lock behavior

p2-importantSemantic gap, missing warning, or undocumented behavior that affects correctnessSemantic gap, missing warning, or undocumented behavior that affects correctness

Status: Open.

#331 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

BUG (P1): Hardware diagnostics report host physical_memory_kb in containers — direct misconfiguration risk

azureAzure SQL Database / Managed Instance specific behaviorAzure SQL Database / Managed Instance specific behavior

bugSomething isn't workingSomething isn't working

containersContainer/Docker/Kubernetes/AKS deployment behaviorContainer/Docker/Kubernetes/AKS deployment behavior

p1-criticalBug or defect that causes incorrect behavior, data loss, or silent failureBug or defect that causes incorrect behavior, data loss, or silent failure

Status: Open.

#330 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

BUG (P1): RESAMPLE_PERSIST path has no histogram quality floor — silently builds degraded histograms on low-sample stats

bugSomething isn't workingSomething isn't working

p1-criticalBug or defect that causes incorrect behavior, data loss, or silent failureBug or defect that causes incorrect behavior, data loss, or silent failure

Status: Open.

#329 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

BUG (P1/Security): @WhatIfOutputTable SQL injection defense is inert on CREATE path and incomplete on INSERT path

bugSomething isn't workingSomething isn't working

code-qualityRefactoring, dead code removal, maintainability, or internal correctnessRefactoring, dead code removal, maintainability, or internal correctness

p1-criticalBug or defect that causes incorrect behavior, data loss, or silent failureBug or defect that causes incorrect behavior, data loss, or silent failure

Status: Open.

#328 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

BUG (P1): MAX_GRANT_PERCENT hint placed on metadata SELECT, not on UPDATE STATISTICS execution

bugSomething isn't workingSomething isn't working

p1-criticalBug or defect that causes incorrect behavior, data loss, or silent failureBug or defect that causes incorrect behavior, data loss, or silent failure

performanceExecution speed, resource usage, or scalability of the procedure itselfExecution speed, resource usage, or scalability of the procedure itself

Status: Open.

#327 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 16, 2026

ENHANCEMENT (P3): Add ROWLOCK hint to reduce lock escalation in parallel UPDATE STATISTICS

enhancementNew feature or requestNew feature or request

p3-nice-to-haveLow-impact enhancement or minor improvementLow-impact enhancement or minor improvement

Status: Open.

#326 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 14, 2026

ENHANCEMENT: Pre-execution warning when forced plans + AUTOMATIC_PLAN_CORRECTION enabled

enhancementNew feature or requestNew feature or request

p2-importantSemantic gap, missing warning, or undocumented behavior that affects correctnessSemantic gap, missing warning, or undocumented behavior that affects correctness

Status: Open.

#325 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 14, 2026

phase_loss_cursor, join_cursor, and temporal_cursor use row-by-row iteration for operations expressible as set-based string aggregation — procedural anti-pattern

p4-deferredValid but deferred to future releaseValid but deferred to future release

persona-reviewIssue generated via SQL SME persona code reviewIssue generated via SQL SME persona code review

triage-reviewedReviewed and triaged 2026-03-11Reviewed and triaged 2026-03-11

Status: Open.

#317 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Mar 11, 2026