db-Berater GmbH
  • Home
  • Services
  • Workshops 
  • Referenzen
  • Blog
  • Download
  • Kontakt
Seite wählen
Update Statistics from Replicated Database

Update Statistics from Replicated Database

von Uwe Ricken | Okt. 24, 2026 | 300, SQL Blog

One of the ongoing challenges in database administration is SQL Server statistics maintenance. On large production systems, updating statistics can consume significant resources and affect critical workloads. This article demonstrates how transactional replication,...

db SQL Blog

  • Forced Parameterization and its Impact on Interleaved Execution
    SQL Server plan cache showing four entries under Forced Parameterization: one compiled plan for the MSTVF demo.get_c_custkey_list_by_nation (objtype = Proc, usecounts = 2), two separate Adhoc entries for the original queries containing the literals 'AUSTRIA' and 'PORTUGAL' (usecounts = 1 each), and one Prepared plan for the automatically parameterized query (usecounts = 2).
  • Why I Don’t Use Query Hints Before Understanding What the Optimizer Is Doing
    Extended Events session capturing the lifecycle of Interleaved Execution for a Multi-Statement Table-Valued Function (MSTVF). The trace starts with a recompilation event (recompilation_for_interleaved_exec), followed by statement execution events. Three interleaved_exec_status events document the progression through the Interleaved Execution framework: status 0 indicates eligibility detection, status 1 indicates that SQL Server executes the MSTVF during optimization to obtain actual cardinality information, and status 2 indicates that optimization resumes using the observed row count. The event sequence confirms that SQL Server pauses optimization, executes the MSTVF, and recompiles the query using the actual cardinality returned by the function.
  • Table Variable Deferred Compilation Disabled! So Why Does SQL Server Still Recompile?
  • Interleaved Execution: The Cure for MSTVFs That Never Cured Parameter Sniffing
    Extended Events output showing the compilation, execution, and recompilation phases of SQL Server Interleaved Execution for a Multi-Statement Table-Valued Function
  • MSTVFs: Better Estimates, Same Fundamental Problem
    Execution plan demonstrating Interleaved Execution for a Multi-Statement TVF with accurate cardinality estimation of 3,776 rows.
  • Update Statistics from Replicated Database
    Infrastructure of automated stats update from a subscriber to a publisher
  • SQL Server Forced Parameterization: When It Improves Performance and When It Doesn’t
  • Nonfoldable User Defined Functions
  • CTE vs temp table performance in SQL Server. Hidden costs and real workload impact!
  • Partition a big table with zero downtime
    Data Flow Between Application, Orders View, and Backend Tables
  • WHERE 1 = 1 – good practice?
  • Table Hint UPDLOCK and LOCK ESCALATION
  • Auto Update Statistics and Trivial Execution Plans
    Execution process of trivial plans with simple parameterization
  • When „Auto Update Statistics“ will not update your statistics
  • Is SWITCH PARTITION a bad idea?
  • Datenschutzerklärung
  • Impressum
  • Sitemap
  • Download
  • RSS

db Berater GmbH | | Büchenweg 4 | 64390 Erzhausen | Phone: +49 (0) 6150 5082955 | E-Mail: info@db-berater.de Amtgericht Darmstadt: HRB86305 |    Umsetzung