SQLBits 2018

Kick Start! SQL Server 2016/2017 Performance Tips and Tricks

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has introduced many new features. In this 75 minute session we will be learning quite a few of the new features of SQL Server 2016 / 2017. Here is the glimpse of the features we will cover in this session.

• Adaptive Query Plans
• Batch Mode Adaptive Join
• New cardinality estimate for optimal performance
• Adaptive Query Processing
• Indexing Improvements
• Introduction to Automatic Tuning

This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2016 / 2017 and its new features.