DPS 2020 Training Class – Query Tuning- by Erik Darling
Visit DPS 2020 More Training Classes Book Now
|
Pre-Con Title |
The Beginner’s Guide To Advanced Performance Tuning |
|
Track(s) |
Development |
|
Tags |
#PerformanceTuning #Index #Query #Plan #T-SQL |
|
Level |
Basic |
|
Trainer/Speaker |
|
|
Abstract |
You’re new to SQL Server, and your job more and more is to fix performance problems, but you don’t know where to start. You’ve been looking at queries, and query plans, and puzzling over indexes for a year or two, but it’s still not making a lot of sense. Beyond that, you’re not even sure how to measure if your changes are working or even the right thing to do. In this full day performance tuning extravaganza, you’ll learn about all the most common anti-patterns in T-SQL querying and indexing, and how to spot them using execution plans. You’ll also leave knowing why they cause the problems that they do, and how you can solve them quickly and painlessly. If you want to gain the knowledge and confidence to tune queries so they’ll never be slow again, this is the training you need. |
|
Modules/Topics |
In this course we’ll be talking about how to read query plans to spot problems, query writing anti-patterns, what makes a good index, how parameterization works, and how to make sure your queries are reliably fast. |
|
Attendee Pre-requisite (if any) |
1-2 years working with SQL Server, knows how to write basic queries, the difference between clustered and nonclustered indexes, and how to find query plans. |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day). Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
