Jan 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
Propagation Compatibility Level

SQL SERVER – AlwaysOn and Propagation of Compatibility Level

February 17, 2021
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Compatibility Level, Database Compatible Level, SQL High Availability, SQL Mirroring, SQL Server

It is not possible to Propagation of Compatibility Level in AlwaysOn or mirroring from primary to secondary mirroring. Let us learn it today.

Read More
After Upgrading

SQL SERVER 2019 – Performance Issues After Upgrading from SQL Server 2012

October 15, 2020
Pinal Dave
SQL Performance
Cardinality, Compatibility Level, SQL Scripts, SQL Server

They reached out to me to help them fix their SQL Server Performance issues after upgrading. Comprehensive Database Performance Health Check.

Read More
batch mode

SQL SERVER – Batch Mode in RowStore – Performance Comparison

November 21, 2019
Pinal Dave
SQL Performance
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.

Read More
Compatibility Level

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.

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2022 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version