Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Friday, October 2, 2015 4:51 PM
Hi,
I am looking for a document that shows the comparison between SQL Server 2014 and SQL Server 2016, for example performance, functionality, pros and cons of each other, that kind of material would be great and would be better if it is documented in an official or non-official document. Any information would be helpful for me.
Thanks in advance,
Andrés Solano A.
Friday, October 2, 2015 5:24 PM ✅Answered | 2 votes
Hello,
Please read the following resources:
http://www.code-sample.com/2015/07/sql-server-2016-vs-sql-2012-and-2014.html
The following may be useful:
https://msdn.microsoft.com/en-us/library/bb500435(v=sql.120).aspx
https://msdn.microsoft.com/en-us/library/bb500435(v=sql.130).aspx
Comparison of In-memory OLTP between both versions:
http://sqlperformance.com/2015/05/sql-server-2016/in-memory-oltp-enhancements
Always ON improved on SQL Server 2014 and improved again on SQL Server 2016.
Fixes for bugs found on the SQL Server 2014 cardinality estimator, are now present on the SQL Server 2016 version by default. No need to enable them.
Live Query statistics (part of SQL 2016) are available on SQL Server 2014 only if you use SSMS 2016 and SQL 2014 SP1.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
Friday, October 2, 2015 4:59 PM
Hi,
In my job we are looking for information related to SQL Server 2014 and SQL Server 2016 since we are going to make a migration of our actual SQL Version, so we need to decide which is better between this two version.
I know that 2016 is the latest version of SQL, beside is the newest version I need to know why it is better or worst than SQL Server 2014.
We are looking for a document that shows the comparison between SQL Server 2014 and SQL Server 2016, for example performance, functionality, pros and cons of each other, that kind of material would be great and would be better if it is documented in an official or non-official document. Any information would be helpful for me.
So please let me know your ideas and experience.
Thanks in advance,
Andrés Solano A.
Friday, October 2, 2015 9:07 PM | 2 votes
I would say that the most important factor for your decision is when you plan to do the migration. SQL 2016 is only in CTP, and no release date has been announced. Also, it is not feature-complete. That is, more feature will be added with later CTPs.
So if you are aiming going live with the new SQL Server version within the next six months, you should aim at SQL 2014.
But if you think that it would take another twelve months, then you should aim at SQL 2014. Generally, you should always upgrade to the most recent recently version of SQL Server. This assumes that you don't other dependencies, for instance you are running some third-party application where the vendor only supports certain versions of SQL Server.
Reading documents that compare the two version is only meaningful if you are looking for specific new features in SQL 2016 that are useful enough for you to defer your migration until SQL 2016 has been released. (Note that you can start testing your application before RTM, but you cannot go live before RTM, unless you get on the TAP program.)
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se