SQLBits 2018

Exploring Execution Plans

Learn the details behind how to read execution plans.

Getting started reading execution plans is very straight forward. The real issue is understanding the plans as they grow in size and complexity. This session will show you how to explore the nooks and crannies of an execution plan in order to more easily find the necessary information needed to make what the plan is telling you crystal clear. The information presented here will better empower you to traverse the execution plans you’ll see on your own servers. That knowledge will make it possible to more efficiently and accurately tune and troubleshoot your queries.

Speaker

Grant Fritchey, SQL Server MVP, works for Redgate Software as a Product Advocate. He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server Query Performance Tuning (Apress).

Grant Fritchey's Sessions

Managing the Challenge of Monitoring Growing, Multi-platform Database Estates

The New Database Landscape - Revealing Shifts and Charting the Next Horizon

Fundamentals of Git

Efficiency up, failed releases down; compliant production data for your test and dev environments

Benefits of Using Version Control In Database Development

Yes, You Should Monitor Azure SQL Database

SQL Injection: How it Works, How to Stop It

Learn to Read Execution Plans

Environment Provisioning: The Third Age

DevOps and Data

Exploring Execution Plans

Statistics, Row Counts, Execution Plans, and Query Tuning

Faster Provisioning with SQL Clone

Automating Your Database Deployments

Getting Started Reading Execution Plans

Monitoring Windows Azure SQL Server VMs and SQL Databases

Query Tuning in the Clouds