Joey on SQL Server. A Deep Dive into SQL Server 2022's Query Performance Features, Part 1. An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to ...

SQL Server 2022 can use percentiles to improve the feedback algorithm for queries where the amount of memory changes a lot each time users run them, and persist memory grants feedback even if ...

In SQL Server 2017, automatic plan correction was added, which allows for the database engine to automatically use the "last known good plan" for a query that has suddenly regressed in performance.

Microsoft pulled the Cumulative Update package 7 (CU7) for SQL Server 2019 released on September 2 after confirming a known reliability issue impacting customers who used the database snapshot ...