Compatibility Level Archives - SQL Authority with Pinal Dave

May Discount 33% | Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Batch Mode in RowStore – Performance Comparison

November 21, 2019

Batch Mode, ColumnStore Index, Compatibility Level, Execution Plan, SQL Scripts, SQL Server, SQL Server 2019

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

November 13, 2019

Pinal Dave

SQL Tips and Tricks

Compatibility Level, SQL Scripts, SQL Server, SQL Server Configuration

One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.