Opleiding: SQL Server Performance Tuning

Leer de basis van performance tuning en verbeter de performance van je SQL queries

Je leert de essentiële onderdelen van SQL Server performance tuning kennen.
Denk hierbij aan onderwerpen als indexing best practices en hoe je query plans moet lezen. Vervolgens los je zelf veelvoorkomende problemen op in een serie 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:
- Understand the common elements in exe…