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 ...

Since SQL Server 2016, you have had the ability to force a "known good" execution plan for a given query. Plan forcing can be used after a version upgrade to lock into a good plan, or to quickly ...