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. 30, 2026 | 300, DB Engine, SQL Blog
For years, SQL Server professionals are using Multi-Statement Table-Valued Functions (MSTVFs). The concept of „reusability“ of code originates from high-level programming languages and appears equally attractive for database projects. For this reason,...
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,...
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 | Okt. 16, 2026 | 300, SQL Blog
Most SQL Server professionals know that wrapping a column in a function can kill SARGability. Far fewer realize that putting a user-defined function on the other side of the predicate can be just as dangerous. The reason isn’t the function itself. It’s...
von Uwe Ricken | Okt. 8, 2026 | 300, SQL Blog
CTE vs temp table performance in SQL Server is one of those evergreen debates that never seems to fade. The recent MSSQLTips article by Mehdi Ghapanvari compares both approaches and concludes that temp tables sometimes win because of better cardinality estimation...
