Opleiding: Workshop SQL Server Performance Tuning Fundamentals

Understand and practice with the basics of SQL Server Performance Tuning

During this training you will learn to recognize common performance issues in SQL Server. This includes topics such as indexing & statistics best practices and learning how to read query plans. After this, you will solve these issues yourself through a series of hands-on labs.
- Table & Query Design
- Indexing in SQL Server
- Query Execution Plans
- Common Database Objects
- Locking, Query Hints and Monitoring

In this chapter we will discuss the impact of basic choices in your table design and query strategy.
Goals:
- Learn about normalization and why it is important.
- Understand the benefits of set oriented SQL code
- Learn about Data Types, Keys and constraints in tables
- Get to know temporary tables

In this chapter we discuss the different index options in SQL Server and when to use them.
Goals:
- Understand the difference between Heap, Clustered and Nonclustered Indexes
- Know when to create and index
- Check whether your index works as intended
- Learn about the different options when creating indexes

In this chapter we will dive deeper into query execution plans. How to read them, what can you encounter, how can they be used?
Goals:
- Understan…