Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to query tuning? When you look at execution plans, do you understand how to interpret and analyze them? Are your queries slow? And yet you don’t know how to fine tune them and improve them?
If so, join my SQL Server Query Tuning Workshop, where you’ll learn everything you need to know to master SQL Server query tuning and boost your database performance.
In this 2-day long online training you will learn about:
- Execution Plans
- Overview
- Input Trees
- Estimated Execution Plan
- Actual Execution Plan
- How to access your data through Indexes
- Clustered Index
- Non-Clustered Index
- Index Scans
- Index Seeks
- Physical Operators
- Data Access Operators
- Join Operators
- Aggregation Operators
- Spool Operators
- Halloween Protection
- Index Tuning Strategies
- Search Arguments
- Bookmark Lookups
- Tipping Point
- Index Intersection
- Filtered Indexes
- Indexed Views
- Statistics
- Auto Create
- Auto Update
- Fill Factor
- Statistics Analysis
- Multi-Column Statistics
- Plan Caching & Parameter Sniffing
- Adhoc Query Caching
- Parameterization
- Optimize for Adhoc Workloads
- Recompilations
- Plan Guides
