During my parameter sniffing classes, people get a little exasperated with the complexity of the problem. Parameter sniffing is totally hard. I get it. At some level, it’d be great to just hit a magic button and make the whole thing go a...
By Huy Vũ
Recently I covered some of the T-SQL improvements in SQL Server 2022 here, and Aaron Bertrand covered additional improvements here. Those improvements were introduced in CTP 2.0. Microsoft just announced the release of SQL Server 2022 CT...
By selectgo
Introduction The SQL Server query optimizer makes use of statistics during query compilation to help determine the optimal query plan. By default, if the optimizer notices a statistic is out-of-date because of too many changes to a table...
By Huy Vũ
SQL Server 2022 (16.x) and Later · All Editions · Facts Verified from Microsoft Learn Every fact in this article is sourced directly from Microsoft Learn documentation. Nothing is guessed, inferred from community posts, or carried over f...
By Huy Vũ
SQL Server’s Query Store is the closest thing the engine has to a flight data recorder. Before Query Store existed, when a query suddenly became slow there was often no evidence to work with. The execution plan that caused the problem wa...
By Huy Vũ
About three years ago, SQL Server 2022 introduced Parameter-Sensitive Plan Optimization (PSPO). At the time, I explained that it didn’t work particularly well, and went so far as to pronounce PSPO in a rather unflattering way. I wouldn’t...
By Huy Vũ
