As the biggest leap forward in Microsoft’s data platform history, SQL Server 2016 delivers breakthrough mission critical performance, deeper insights across any data on many devices and enables the power of hyperscale cloud to unlock new hybrid scenarios.
This page compares all available configuration options for both SQL Server 2016 and SQL Server 2014, showing the range of possible settings and default values.