This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     
decoration
decoration
decoration

SQL Server Query Tuning Workshop

20th October 2014 - 23rd October 2014

Who is it for?

This course is aimed at SQL Server DBAs and developers. 

What you will learn

Module 1: Query Processing Basics

  • Set Theory
  • Predicate Logic
  • Relational Model
  • Logical Query Processing
  • Algorithms and their Complexity

Module 2: Physical Query Processing

  • Execution Plans
  • Data Access Paths
  • Physical Join Operators
  • Aggregation Operators
  • Spool Operators

Module 3: Index Tuning

  • Search Arguments
  • Bookmark Lookups
  • Tipping Point
  • Index Intersection
  • Filtered Indexes
  • Indexed Views

Module 4: Index Impact Analysis

  • The Double Edged Sword of Indexing
  • Workload Capturing
  • Workload Replaying
  • Measure Index Impacts

Module 5: Statistics

  • Overview
  • Auto Create/Auto Update Statistics
  • Histogram
  • Density Vector
  • Filtered Statistics

Module 6: Cardinality Estimation

  • Overview
  • Conjunctions
  • Disjunctions
  • Column Correlations
  • Ascending Key Problem

Module 7 & 8: Querying multiple Tables

  • Joins & Set Operations
  • Sub Queries
  • Correlated Sub Queries
  • Table Expressions

Module 9: Temporary Data & Aggregations

  • Temp Tables
  • Table Variables
  • Common Table Expressions
  • Aggregations & Pivoting

Module 10: Dynamic SQL

  • EXEC & sp_executesql
  • Parametrization
  • SQL Injection
  • Dynamic Search Conditions

Module 11: Windowing Functions

  • Overview
  • OVER Clause
  • Window Aggregate Functions
  • Ranking Functions

Module 12: Working with Windowing Functions

  • Paging
  • Running Totals
  • Interval Queries
  • Gaps & Islands

Module 13: Parallel Execution Plans

  • Parallelism Operators
  • Degree of Parallelism
  • Bitmap Filtering
  • Restrictions

Module 14: In-Memory OLTP

  • Reasons for In-Memory OLTP
  • Main Pillars
  • Scalability
  • Limitations

Module 15: ColumnStore Indexes

  • Overview
  • Changing Data
  • Segment Elimation
  • Query Memory Grants

Module 16: Advanced Query Optimization

  • Plan Simplification
  • Trivial Plans
  • Cost-Based Optimization
  • Search Phases

Key Benefits

  • Learn how to write high performance T-SQL queries
  • Understand and apply the difference between logical and physical query processing
  • Getting a detailed knowledge about execution plans and how to optimize performance
  • Applying indexing strategies to your performance problems
  • Evaluate if In-Memory technologies make sense for your database

Cost: £1499 (to 31 August 2014) 1599 (from 1 September 2014) +VAT
decoration

Trainer

Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.

decoration

Location

Skills Matter
116-120 Goswell Road
decoration

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration
decoration decoration decoration decoration
decoration
decoration