The new CE feedback feature in SQL Server 2022 will allow the engine to make decisions on an individual query level, which will help the performance to even more queries on a server.

SQL Query Store is a new feature offered in SQL Server 2016 that allows DBAs to see which queries ran when, how often and with what performance results to optimize queries and query plan selection.

In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

Planning Queries It's worth recognizing that many SQL statements aren't, in fact, planned in any meaningful sense. One of the first things that the SQL Server optimizer does when it sees a query is ...

While the last two versions of SQL Server focused on improving performance by offering new features, SQL Server 2016 looks inwards towards improving existing functionality.

By combining machine learning and adaptive query execution, query optimization in Presto could become smarter and more efficient over repeated use. Topics Spotlight: AI-ready data centers ...

Joey on SQL Server. Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization. Reduce workload times with this handy feature that can benefit every database pro.