SQL Server Query Tuning Strategies
Key Concepts Covered in this Course
- Index Tuning Strategies
- Pro's and Con's around Lookup Operations
- Troubleshooting Plan Cache Issues
- Resolving Parameter Sniffing Problems
Klaus Aschenbrenner
Microsoft Certified Master for SQL Server
I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.
Since 2012 I’m also a Microsoft Certified Master for SQL Server.
Course Description
If you have a database driven application which reacts very slowly when the data increases, then you are right in this online training! You will learn how you can tune SQL Server Queries with concrete Index Tuning Strategies.
You will also learn how SQL Server caches and reuses Execution Plans, and which terrible problems can occur in SQL Server based on this behaviour.
Amazing Course
“Based on that knowledge I finally know now why sometimes queries are fast, and sometimes are slow. It was an amazing training, which makes the day-to-day work with SQL Server now very easy.”
Thomas from St. Margrethen/Switzerland
Course Details
Course Duration
6 hours
Course Price
EUR 229 inkl. 20% VAT
Course Level
Beginner