Our PSS engineers have built a series on “It Just Runs
Faster”!
“In the Sep
2014 the SQL Server CSS and Development teams performed a deep dive focused on
scalability and performance when running on current and new hardware
configurations. The
SQL Server Development team tasked several individuals with scalability
improvements and real world testing patterns. You can take advantage of this effort
packaged in SQL Server 2016. – https://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/”
SQL 2016 will run faster in many ways, without changing
code.
The series kickoff is here:
The first article in this series came out the end of
February:
SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better
The announcements so far in March are:
SQL 2016 – It Just Runs Faster: DBCC Extended Checks
SQL 2016 – It Just Runs Faster: Native Spatial
Implementation(s)
SQL Server Parallel Query Placement Decision Logic
SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)
