9 articles
Great volumes have been written about table partitioning. It’s a complex feature and you can read for days to just understand how you might apply it. But will it improve performance for you? Table partitioning produces great benefits for...
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ũ