Developers Choice: USE HINT query hints

Cross post with http://aka.ms/sqlserverteam The use of Trace Flags has always been understood as a sort of ‘hack’, and a solution that is hard to manage and sometimes understand (namely because it depends on a number). Over the years, users have seen several knobs added to SQL Server to influence the Query Optimizer. These trace…

0

Developers Choice: CREATE OR ALTER

Cross post with http://aka.ms/sqlserverteam Today we are starting a new blog post series entitled “Developers Choice”. In the first few posts we will be focusing on SQL Server 2016 SP1 enhancements that focus on the developer community, including all developer DBA’s. Following in the same reasoning of simplifying DDL statements that was started by the…

0

New Showplan XML properties in SSMS October Release

Cross post with http://aka.ms/sqlserverteam Back in March we announced the availability of per-operator level performance stats for Query Processing (exposed in Showplan XML) with SQL Server 2014 SP2 and SQL Server 2016. However, SQL Server Management Studio (SSMS) did not expose this information, and so users had to look in the Showplan XML, in the…

2

24HOP – Portuguese Edition 2016

Hello all, if you’re a Portuguese speaker, come join me on 11/16 for a 24HOP session on “Gems to help you troubleshoot query performance”. Starts at 21h GMT or 19h BR. Description: SQL Server 2012 Service Pack 3, SQL Server 2014 Service Pack 2 and SQL Server 2016 introduced enhancements to support execution plan analysis. Join…