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: Parallel Execution Plans

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

Module 11 & 12: Working with Windowing Functions

  • Window Aggregate Functions
  • Ranking Functions
  • Distribution Functions
  • Offset Functions
  • Query Tuning Guidelines
  • Parallelism Optimizations

Module 13: In-Memory OLTP

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

Module 14: ColumnStore Indexes

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

Module 15 & 16: Inside the Query Optimizer

  • Optimization Pipeline
  • Cost-Based Optimization
  • Rules
  • Optimization 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