SQL Server 2016

Measure Delayed Durability impact

In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.

Memory limits in SQL Server 2016 SP1

I explain a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.

A BIG DEAL: SQL Server 2016 Service Pack 1

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

STRING_SPLIT: Follow-up #2

With additional tests comparing splitting techniques to TVPs, I round out my series on STRING_SPLIT() in SQL Server 2016.

STRING_SPLIT: Follow-up #1

I follow up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

Performance surprises: STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT; I compare its performance to existing methods.

SQL Server 2016: JSON support

I walk through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.