SQL with Manoj

Microsoft 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:

https://blogs.msdn.microsoft.com/psssql/2016/02/23/sql-2016-it-just-runs-faster-announcement/
 

The first article in this series came out the end of February:

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better
https://blogs.msdn.microsoft.com/psssql/2016/02/25/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
https://blogs.msdn.microsoft.com/psssql/2016/03/01/sql-2016-it-just-runs-faster-dbcc-extended-checks/

SQL 2016 – It Just Runs Faster: Native Spatial Implementation(s)
https://blogs.msdn.microsoft.com/psssql/2016/03/03/sql-2016-it-just-runs-faster-native-spatial-implementations/

SQL Server Parallel Query Placement Decision Logic
https://blogs.msdn.microsoft.com/psssql/2016/03/04/sql-server-parallel-query-placement-decision-logic/

SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)
https://blogs.msdn.microsoft.com/psssql/2016/03/08/sql-2016-it-just-runs-faster-tvps-with-spatial-columns/

SQL 2016 – It Just Runs Faster: Spatial Index Builds Faster
https://blogs.msdn.microsoft.com/psssql/2016/03/10/sql-2016-it-just-runs-faster-spatial-index-builds-faster/

SQL 2016 – It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases
https://blogs.msdn.microsoft.com/psssql/2016/03/15/sql-2016-it-just-runs-faster-t1117-and-t1118-changes-for-tempdb-and-user-databases/

SQL 2016 – It Just Runs Faster: Automatic TEMPDB Configuration
https://blogs.msdn.microsoft.com/psssql/2016/03/17/sql-2016-it-just-runs-faster-automatic-tempdb-configuration/

SQL 2016 – It Just Runs Faster: LDF Stamped
https://blogs.msdn.microsoft.com/psssql/2016/03/22/sql-2016-it-just-runs-faster-ldf-stamped/

SQL 2016 – It Just Runs Faster: Instant File Initialization
https://blogs.msdn.microsoft.com/psssql/2016/03/25/sql-2016-it-just-runs-faster-instant-file-initialization/

SQL 2016 – It Just Runs Faster: Automatic Soft NUMA
https://blogs.msdn.microsoft.com/psssql/2016/03/30/sql-2016-it-just-runs-faster-automatic-soft-numa/
 

Check my blog posts on most of the new features released in SQL Server 2016 here
https://sqlwithmanoj.com/sql-server-2016-articles/