Feature
An ExpertMode diagnostic result set that reconstructs a runnable repro for queries that regressed after a statistics update: for each regressed Query Store plan on a table whose stats a run updated, mine the sniffed parameter values from the plan XML ParameterList, replay the plan's set_options bitmask as SET statements, and emit a ready-to-run sp_executesql block plus a warnings taxonomy (missing temp objects, scoped credentials, etc.).
This turns "query X got slower after the stats run" from an accusation into a testable artifact.
Pattern source: sp_QueryReproBuilder (DarlingData) — three of its blocks (parameter mining, set_options fidelity, statement assembly) are self-contained and portable.
Feature
An ExpertMode diagnostic result set that reconstructs a runnable repro for queries that regressed after a statistics update: for each regressed Query Store plan on a table whose stats a run updated, mine the sniffed parameter values from the plan XML
ParameterList, replay the plan'sset_optionsbitmask as SET statements, and emit a ready-to-runsp_executesqlblock plus a warnings taxonomy (missing temp objects, scoped credentials, etc.).This turns "query X got slower after the stats run" from an accusation into a testable artifact.
Pattern source: sp_QueryReproBuilder (DarlingData) — three of its blocks (parameter mining, set_options fidelity, statement assembly) are self-contained and portable.