This post will look at the oldest compatibility supported by SQL Server 2022 (compatibility level 160) and discuss why it is essential.
SQL SERVER – Impact of Changing Database Compatibility Level on Cache
We will explore how changing the compatibility level affects the query cache and why it’s essential to be aware of its impact.
SQL Server 2022 – Cardinality Estimation (CE) Feedback for Performance
SQL Server 2022introduces an enhanced Cardinality Estimation (CE) feedback feature as part of the intelligent query processing family.
SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
SQL SERVER – AlwaysOn and Propagation of Compatibility Level
It is not possible to Propagation of Compatibility Level in AlwaysOn or mirroring from primary to secondary mirroring. Let us learn it today.
SQL SERVER 2019 – Performance Issues After Upgrading from SQL Server 2012
They reached out to me to help them fix their SQL Server Performance issues after upgrading. Comprehensive Database Performance Health Check.
SQL SERVER – Batch Mode in RowStore – Performance Comparison
Let us see in this blog post the performance comparison between Batch Mode and Row Mode. The most asked question was about the Performance difference.