April 3, 2019 at 3:31 pm
Looking to find if there are any benefits of SQL 2017 over SQL 2016. Looking at natively compiled stored procedure improvements in SQL 2016, whereas case statements were included in SQL 2017. Is there any benefits you would like to add,I am looking more towards overall benefits on development and administration side.
April 3, 2019 at 4:49 pm
If you search on "What's new in SQL Server <version>", you an usually find a good list of the changes, improvements from Microsoft Documentation. It's a long list -
https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017?view=sql-server-2017
Sue
April 4, 2019 at 4:42 am
I'd also recommend that you go through the "What's New" to get the complete picture. A few things jump out hard for me, making me recommend 2017 over 2016. Resumable online index rebuilds is pretty huge. Adaptive joins and memory grant adjustments are amazing. The addition of wait statistics to Query Store alone makes the upgrade worthwhile. Finally, the addition of LOB columns to clustered columnstore could be a game changer for some (although I don't think it's that exciting).
"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
April 4, 2019 at 8:33 am
there are a few new language functions, but really not much has changed for developers. For performance and admin, there are more items, as mentioned above. The ability to run in a container is nice for development, and Linux might be something certain people like, but those aren't necessarily items you upgrade for without a specific need.
April 4, 2019 at 8:41 am
I forgot all about Linux (as I sit here working with Linux containers). Yeah, that's another thing, if you need it, that could certainly lead to 2017 over 2016.
"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
April 4, 2019 at 2:57 pm
I typically don't use a lot of the new features simply because I don't have a need. Everyone needs what is mentioned in this link:
Cheers
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply