SQL Server Query Tuning Workshop

Key Concepts Covered in this Course

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!

5/5

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!