von Uwe Ricken | Nov. 13, 2026 | 300, DB Engine, Optimierung, SQL Blog
SQL Server offers several query optimization features designed to improve execution plan quality and overall query performance. Two of these features are Forced Parameterization and Interleaved Execution for Multi-Statement Table-Valued Functions (MSTVFs). At first...
von Uwe Ricken | Nov. 12, 2026 | 300, DB Engine, Optimierung, SQL Blog
Query hints are often treated as a shortcut to solve performance problems. A query doesn’t get the desired plan? Add a hint. Cardinality estimates look suspicious? Add another hint. Parameter sensitivity issues? Surely there’s a hint for that too. Over the...
von Uwe Ricken | Nov. 6, 2026 | 400, DB Engine, Optimierung, SQL Blog
When Microsoft introduced Table Variable Deferred Compilation (TVDC) in SQL Server 2019, table variables finally became capable of generating plans based on actual cardinalities instead of the notorious one-row estimate. If TVDC causes problems, Microsoft provide the...
von Uwe Ricken | Nov. 3, 2026 | 300, DB Engine, Optimierung, SQL Blog
When Microsoft introduced Interleaved Execution, many SQL Server professionals wondered whether this new optimization technique could eventually help address Parameter Sniffing as well. Instead of compiling a plan based on a fixed cardinality guess, the optimizer...
von Uwe Ricken | Okt. 20, 2026 | 300, Optimierung, SQL Blog
Many SQL Server performance tuning discussions focus on indexes, statistics, and query rewrites, while one database option often remains overlooked: FORCED PARAMETERIZATION. In environments flooded with ad hoc queries, SQL Server can spend a surprising amount of time...
von Uwe Ricken | Dez. 28, 2024 | DB Engine, Optimierung, SQL Blog, Statistiken, Tipps und Tricks
Which technique do you prefer when you create a stored procedure and need to work with temporary data? We know there is no definitive answer to this, but there are workloads where a Table Variable is always preferable to a Temporary Table. Workload The stored...