question

chitrarekhasaha avatar image
chitrarekhasaha asked

Choose Microsoft SQL Server 2014 Standard with SP2 or Microsoft SQL Server 2016 Standard with SP1,

We are using sqlserver 2008R2, but microsoft will not be supporting that version. Do I choose Sqlserver 2014 or 2016. Did anyone have any issues with either of them? Which one do you recommend I should use.

sql server 2014
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

206. It'll be under support for longer.

0 Likes 0 ·

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered

Choose the one that is right for the application(s) that this database supports. Are there any features that you need to support, that have been deprecated out or significantly changed in these versions?

In general, given a choice between 2014 and 2016, I would choose 2016, as it is under support for longer (as Thomas said), it will contain improvements over any previous version, and unless you have a reason NOT to use the latest (from the choices given), then why wouldn't you?

So this then brings into the question, SQL2017 - why not consider this?

If you are going to purchase licenses today, then you will be buying 2017 licenses, and you can run earlier versions using something called 'downgrade rights', but if you can move to 2017, then you'll be getting the best value for your money.

And finally if you do go to 2014, you'd be better off choosing the latest patch - ie SP3 - and for SQL2016 it's currently at SP2 CU4.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.