SQLpassion Live Training about Query Tuning Fundamentals

On May 3, 2022 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when the data increases, then you are right in this live training! In this live training you will learn how you can tune SQL Server Queries with the information available inside an execution plan. You will see how SQL Server retrieves data from the database files, how SQL Server can join resultsets, and how you can react with indexes if you are in performance troubles.

During the live training I will cover the following areas:

  • How to access your data through Indexes
    • Heap Tables
    • Clustered Index
    • Non-Clustered Index
    • Index Scans
    • Index Seeks
  • Execution Plans
    • Overview
    • Estimated Execution Plans
    • Actual Execution Plans
    • Data Access Operators
    • Join Operators
    • Aggregration Operators
    • Halloween Protection

SQLpassion Live Training

This one-day long webinar is primarily for DBAs, Developers, and Consultants who want to make their SQL Server installations faster. Please check-out the this link for more details about the online training (detailed agenda, date, pricing) and how to sign-up.

Thanks for your time,

-Klaus

Leave a Comment

Your email address will not be published. Required fields are marked *

Attend my Live Training on September 29, 2022:

SQL Server Availability Groups

EUR 590 incl. 20% VAT