#sql-tuning

What is the maximum compatibility level of Azure SQL

SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries. With PSPO, the SQL Server stores multiple execution plans for a single query, each tailored to different ...