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.
SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.