SQL Server Execution Plans for Beginners: Query Tuning with Jeff Iannucci
Learn how to read SQL Server execution plans, identify common query performance problems, and begin tuning slow T-SQL queries with Jeff Iannucci. Execution plans are one of the most valuable tools available for SQL Server query tuning. They show how SQL Server processes a query, which operations consume the most resources, and where performance bottlenecks may be hiding. In this introductory session, SQL Server expert Jeff Iannucci provides a practical guide to execution plans for DBAs, developers, and database professionals who want to improve T-SQL performance but are not sure where to begin. Jeff explains where to find an execution plan, how to interpret its icons and arrows, which plan details matter most, and how to use those insights to make queries run faster. Topics covered include: What SQL Server execution plans are How execution plans support T-SQL query tuning Where to find estimated and actual execution plans How to interpret execution plan icons, arrows, and operators Which sections of an execution plan deserve the most attention How to identify common SQL Server query performance issues How to locate potential query bottlenecks Practical techniques for improving slow SQL queries Execution plan fundamentals for DBAs and SQL developers This video is ideal for beginning and intermediate SQL Server DBAs, database administrators, SQL developers, database engineers, and anyone responsible for troubleshooting slow queries or improving SQL Server performance. Watch this session to build a practical foundation in SQL Server execution plans and begin making more informed query-tuning decisions. Learn more about SQL Diagnostic Manager: https://www.idera.com/products/sql-diagnostic-manager/ Explore SQL Server query optimization with SQL Diagnostic Manager: https://www.idera.com/products/sql-diagnostic-manager/use-case/sql-server-query-optimization/ Try the free SQL Query Store Optimizer: https://www.idera.com/productssolutions/freetools/sql-query-store-optimizer/ Start a free trial of SQL Diagnostic Manager: https://www.idera.com/products/sql-diagnostic-manager/free-trial/ Visit the IDERA Resource Center: https://www.idera.com/resource-center/ Explore IDERA SQL Server tools: https://www.idera.com/ #SQLServer #ExecutionPlans #QueryTuning #TSQL #SQLServerPerformance #DatabaseAdministration #DBA #SlowQueries #QueryOptimization #IDERA