The Advanced TSQL training course will begin by concentrating on what is needed to be able to improve query and stored procedure performance. Next, it will cover the spectrum of being able to identify and fix poorly performing queries, missing indexes, and unused indexes. The course concludes with a lesson on poor query design and implementation and a basic understanding of wait types and their impact on query performance.
Purpose
|
Learn about advanced topics regarding TSQL. |
Audience
|
Developers using TSQL who want to learn advanced topics like performance and troubleshooting. |
Role
| Software Developer - Web Developer |
Skill Level
| Advanced |
Style
| Fast Track - Targeted Topic - Workshops |
Duration
| 2 Days |
Related Technologies
| .NET | SQL |
Productivity Objectives
- Analyze and revise as needed missing/duplicate/unused indexes.
- Ascertain poorly performing queries/stored procedures and improve their performance.
- Analyze and research wait types affecting system performance and determine corrective actions.
- Apply action when confronted with "The system is running slow".