Search results

sp_StatUpdate: CATCH block increments @consecutive_failures for TOCTOU artifact errors (208/15009) identically to genuine resource failures — add ERROR_NUMBER() routing

Status: Open.

#549 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate: validate absolute rows sampled vs table growth before honoring persisted sample percent

Status: Open.

#548 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

@WhatIfOutputTable: Replace character blocklist with PARSENAME + QUOTENAME defense

Status: Open.

#547 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

@WarningsOut only emits pre-run environmental codes (LOW_UPTIME, BACKUP_RUNNING, AZURE_SQL) — no codes for operational outcomes (TOCTOU_RACES, OVERSHOOT, FORCED_PLANS_DETECTED, CONSECUTIVE_FAILURES)

Status: Open.

#546 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate: @WarningsOut AZURE_SQL code silently misbranches automation for Managed Instance; format contract undocumented

Status: Open.

#545 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate: centralize and correct Query Store WAITS category mapping before reusing it across staged and legacy paths

Status: Open.

#544 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

@MaxConsecutiveFailures CATCH block conflates three structurally distinct error classes into one counter

Status: Open.

#543 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate: replace flat @ThresholdLogic AND/OR stale-stat predicate with a hierarchical qualification rule

Status: Open.

#541 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

@ThresholdLogic=AND incorrectly suppresses high-modification-rate statistics while prioritizing aged low-modification stats

Status: Open.

#540 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate: @StopByTime cannot bound in-flight UPDATE STATISTICS; add overshoot telemetry and pre-call breadcrumbs

Status: Open.

#539 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate runs blind to cross-session monitoring — missing SET CONTEXT_INFO and ##sp_StatUpdate_Progress column depth

Status: Open.

#538 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026

sp_StatUpdate: Split @SkipTablesWithColumnstore — do not skip CCI (type 6) stats maintenance

Status: Open.

#537 In nanoDBA/sp_StatUpdate;

· nanoDBA opened on Jun 8, 2026