May 3, 2021 at 10:32 pm
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?
May 4, 2021 at 8:47 am
I haven't got problems when upgrading to 2019. It introduces adaptive joins which may be finicky in flip-flop scenarios (large & small dataset).
May 4, 2021 at 12:29 pm
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply