SQL Server 2016 Archives - SQLPerformance.com

Instant File Initialization : Impact During Setup

Posted by Aaron Bertrand on March 11, 2016 No Responses »

Mar 112016

SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand (@AaronBertrand) looks at how this can impact tempdb data file creation.

SQL Server 2016 : Availability Group Enhancements

Posted by Aaron Bertrand on December 17, 2015 33 Responses »

Dec 172015

Aaron Bertrand (@AaronBertrand) reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.

SQL Server 2016 : In-Memory OLTP Enhancements

Posted by Aaron Bertrand on November 30, 2015 30 Responses »

Nov 302015

Aaron Bertrand (@AaronBertrand) lists out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.

Practical Processor Selection for SQL Server 2014/2016 OLTP Workloads

Posted by Glenn Berry on September 15, 2015 1 Response »

Sep 152015

Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.

SQL Server 2016 – Introduction to Stretch Database

Posted by Tim Radney on August 18, 2015 2 Responses »

Aug 182015

Tim Radney (@tradney) walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.

Always Encrypted Performance : A Follow-Up

Posted by Aaron Bertrand on August 17, 2015 2 Responses »

Aug 172015

Aaron Bertrand (@AaronBertrand) follows up on his Always Encrypted posts from T-SQL Tuesday with improved code and more information on performance and space usage.