MAIN PRESENTATION (60 min)
In any given SQL Server instance, there are likely 8 to 10 queries or stored procedures that are responsible for 80 to 90 percent of the poorly tuned activity that you see throughout the day. If you can identify these problem queries and tune them, you can make a significant impact on the overall performance of your server. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. This presentation will explain few scenarios of tuning the queries including before and after performance differences. Scenarios such as, use T-SQL new functions like STRING_AGG or TRANSLATE over other old techniques to get better performance or when to use Temp table or table variable.
Raj is a Microsoft Certified Solution Associate, SQL Server 2014 and has over 15 years of SQL Server DBA experience on relational databases, application development and specializes in performance tuning, scalability and maintainability of large scale SQL Servers. During his DBA carrier, he has worked extensively on performance tuning and query optimization projects.
FIRST PRESENTATION (TBD)