SQL Server upgrade from 2017 to 2019

  • We are currently in the process of migrating from Teradata to MSSQL and using SQL Server 2017.  Does anyone know of any good reasons to delay upgrading to 2019 at this time?

  • I haven't got problems when upgrading to 2019. It introduces adaptive joins which may be finicky in flip-flop scenarios (large & small dataset).

  • Nope. It's almost two years old. It was a wildly successful release with very few bugs or issues. What it did have (nothing is perfect) has largely been addressed by cumulative updates over the last couple of years. I'd absolutely recommend any new migrations to SQL Server be done to 2019, not any of the earlier versions.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply