More ways to discover changes in new versions of SQL Server
Following up on an earlier post about metadata, I reveal a few more ways I discover changes in SQL Server.
Monthly Archive: March 2016
Performance Surprises and Assumptions : STRING_SPLIT()
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT; I compare its performance to existing methods.
Instant File Initialization : Impact During Setup
SQL Server 2016 allows you to enable instant file initialization during installation; I look at how this can impact tempdb data file creation.
Extracting ShowPlan XML from SQL Server Extended Events
Tip : Extracting ShowPlan XML from SQL Server Extended Events
Management Studio February Preview: An Illustrated Guide
I talk about some of the nuances of the latest Management Studio preview, with a visual tour through installation.
Bad cardinality estimates from SSMS plans – redux
I share some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
#BackToBasics: The Beauty of the Synonym
In this post, I talke about synonyms and how they can be used.