SQL Server Query Tuning Workshop
Key Concepts Covered in this Course
- Query Processing Fundamentals
- Index Tuning Strategies
- Statistics & Plan Caching
- Working with In-Memory Technologies
Klaus Aschenbrenner
Microsoft Certified Master for SQL Server
I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.
Since 2012 I’m also a Microsoft Certified Master for SQL Server.
Course Description
Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to query tuning? When you look at execution plans, do you understand how to interpret and analyze them? Are your queries slow? And yet you don’t know how to fine tune them and improve them?
Because of these reasons I’m holding my SQL Server Query Tuning Workshop that will cover everything you need to know about SQL Server query tuning.
Info: currently only available on request or as a corporate training!
Amazing Course
“Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis – comes quickly to its limits without knowledge of the operation of SQL Server. The workshop provides an excellent insight into the technical world of SQL Server, explained with many examples of queries and their optimization.”
Ina from Oberhaching, Germany
Course Details
Course Duration
5 Days
Course Price
On request
Course Level
Intermediate
Agenda & Breakdown
Day 1 – Query Processing
- Execution Plans
- Overview
- Input Trees
- Estimated Execution Plan
- Actual Execution Plan
- How to access your data through Indexes
- Clustered Index
- Non-Clustered Index
- Index Scans
- Index Seeks
- Physical Operators
- Data Access Operators
- Join Operators
- Aggregation Operators
- Spool Operators
- Halloween Protection
Day 2 – Index Tuning
- Index Tuning Strategies
- Search Arguments
- Bookmark Lookups
- Tipping Point
- Index Intersection
- Filtered Indexes
- Indexed Views
- GUIDs as Primary Key Values
- Overview
- Index Fragmentation
- Fill Factor
- Primary Key as Non-Clustered Index
- Latch Contentation
Day 3 – Statistics & Plan Caching
- Statistics
- Auto Create
- Auto Update
- Statistics Analysis
- Multi Column Statistics
- Cardinality Estimation
- Conjunctions
- Disjunctions
- Ascending Key Column Problem
- Plan Caching
- Adhoc Query Caching
- Parameterization
- Optimize for Adhoc Workloads
- Parameter Sniffing
- Local Variables
- Recompilations
- Plan Guides
Day 4 – ColumnStore Indexes
- Overview
- Why ColumnStore Indexes
- Advantages
- Limitations
- Changing Data
- Trickle Loading
- Partition Switching
- Improvements in SQL Server 2014/2016
- Operational Analytics
- Why Operational Analytics
- Indexing Guidelines
- Improvements in SQL Server 2016
Day 5 – In-Memory OLTP
- Overview
- Why In-Memory OLTP
- Advantages
- Limitations
- Working with In-Memory OLTP
- Memory Optimized Tables
- Hash Indexes
- Range Indexes
- Hash Collisions
- Native Compiled Stored Procedures
- Transaction Processing
- Writer-Writer Conflicts
- Read-Write Conflicts
- Serializable Violation Conflicts
- Snapshot Violation Conflicts
- Scalability
Info: currently only available on request or as a corporate training!
