News

Redmond Magazine2y
A Deep Dive into SQL Server 2022's Query Performance Features, Part 1
An update to the cardinality estimator feature in SQL ... Azure SQL Database. This functionality allows a DBA to add a query hint (i.e., a direct instruction to the optimizer to bypass an ...
Redmond Magazine2y
Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization
In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization ... (I ran this demo on Azure VM with 16 GB ...