SQL Server Query Performance Tuning (2 days)


SQL Server is easy to start working with but there can be a lot to learn before you get the best possible performance from it.

This course is one of our most favourite courses and covers SQL Server table structures, indexing and performance, with just the right depth, and within two days.

The course is targeted at application developers that are generating T-SQL queries and designing SQL Server applications and also to existing SQL Server developers and DBAs.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us


DAY 1 QP201 SQL SERVER INDEXING CORE CONCEPTS
Core Indexing Concepts
Table and Index Structures
Index Effectiveness
LAB: SQL Server Indexing Core Concepts
DAY 1 QP202 DESIGNING EFFECTIVE INDEXES FOR SQL SERVER
Indexing for Constraints
Clustering Keys and Data Types
Indexing Strategies
LAB: Designing Effective Indexes for SQL Server
DAY 1 QP203 WORKING WITH QUERY PLANS
Understanding Execution Plans
Capturing Execution Plans
Data Collection and Query Store
LAB: Working with Query Plans
DAY 1 QP204 READING SQL SERVER EXECUTION PLANS
Common Plan Elements
Join Strategies
Aggregations
Data Modifications
Views and Indexed Views
Query Hints
LAB: Reading SQL Server Execution Plans
DAY 2 QP205 TRACING AND PROFILING SQL SERVER QUERIES
SQL Server Profiler
Query Tracing using SQL Trace
Query Tracing using Extended Events
Identifying Queries to Optimize
LAB: Tracing and Profiling SQL Server Queries
DAY 2 QP206 SQL SERVER TRANSACTIONS AND CONCURRENCY
Transaction Isolation Levels
Lock Modes, Hints, Duration, and DMVs
Deadlocks
Row Version Tables
LAB: SQL Server Transactions and Concurrency
DAY 2 QP207 MAINTAINING QUERY EFFICIENCY
Index and Heap Fragmentation
Query Compilation and Plan Caching
Cursors vs Set-Based Operations
Temporary Tables vs Table Variables
LAB: Maintaining Query Efficiency
DAY 2 QP208 WORKING WITH IN-MEMORY TABLES AND INDEXES
Memory-Optimized Tables
Indexes on Memory-Optimized Tables
Natively-Compiled Modules
LAB: In-Memory Tables and Indexes