Have you ever developed slowly running queries and wondered how to tune your SQL Server queries? In this session you will learn some T-SQL performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go over basic indexing concepts for improving workloads. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to optimize them.
Resources
SQL Server Root Cause Analysis in 10 Minutes
Download Sample Scripts
Build the Enlarged Tables
Pingback: Austin .NET SQL User Group Presentation | JohnSterrett.com SQL Server Consulting
Pingback: Extended Event Security Permissions | JohnSterrett.com SQL Server Consulting
Pingback: PASS Performance – SQLPalooza 2015! | Jan's Blog