SQLskills IEQuery - SQL Server 2019
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems. IEQuery gives everyone that works with SQL Server a better understanding of how to analyze and troubleshoot poor query performance. Part I: Capturing Query Information and Analyzing Plans by Erin Stellato. Part II: Removing Anti-Patterns in Transact-SQL by Jon Kehayias. Part III: Differentiating Caching / Statistics problems and SOLVING THEM by Kimberly Tripp.
- Type Learning
- Level Intermediate
- Time Days
- Cost Paid
Skills
- Architectural Overview Of SQL Server And Components
- Baselining Options And Considerations For Tuning Query Performance Problems
- Capturing And Comparing Execution Plans
- Compare And Contrast: Literals | Variables | Parameters
- Comparing And Contrasting Sources Of Query Performance Data
- Creating Additional Column-based Statistics
- Design Considerations That Affect Query Performance
- Finding Essential Information In A Query Plan
- Measuring Performance Metrics For Query Tuning
- Profiling Performance During Development
- Reducing And Eliminating Row-by-bow Processing
- Removing Anti-patterns In Transact-sql
- Resolving Statement Execution Caching Problems
- Set-based V. Row-based Processing Concepts For Developers
- SQL Server Database Structures
- SQL Server Internals
- Statement Auto-parameterization
- Troubleshooting And Maintaining SQL Server Statistics
- Understanding Sargability In Query Constructs
- Understanding The Life Of A Plan In Cache