• T-SQL for Developers

  • 2 Day Course  |  £795.00 (+VAT)

Target Audience

This course is aimed at Developers who are using SQL Server and wish to expand their knowledge in order to write more performant t-SQL and avoid causing any server bottlenecks.

Required Knowledge

Basic T-SQL knowledge
Basic Execution Plan Analysis

Purpose of the Course

The purpose of this course is to ensure that Application Developers who use SQL Server understand some SQL Server internals in order to write highly performant and re-usable code when developing their applications.

Topics Covered

  • Basic Execution Plan Analysis
  • Indexing
  • Internal Join Types
  • Memory Grants
  • Cost Based Queues
  • Statistics
  • Parameter Sniffing
  • Parallelism
  • Intermediate Execution Plan Analysis

Course Modules

Module 1: Basic Execution Plan Analysis

  • At a Glance
  • Reads / Writes
  • The 8K Page
  • Execution Plan Warnings

Module 2: Indexing

  • Clustered Indexes
  • Non Clustered Indexes
  • Key Columns vs Included Columns
  • Filtered Indexes and gotchas

Module 3: Optimizer Join Types

  • Loop Join
  • Merge Join
  • Hash Join
  • vNext

Module 4: Memory Grants

  • Spills
  • Concurrency

Module 5: Statistics

  • How to Read a Statistic
  • Performance Impact
  • Statistics Maintenance Tips
  • Filtered Statistics
  • Incremental Statistics

Module 6: Parallelism

  • How it works
  • Performance Boost
  • Performance Pitfalls
  • Optimizer Flaws

Module 7: Cost Based Queues

  • Query Cost
  • Costing Pyramid
  • Concurrency Issues

Module 8: Parameter Sniffing

  • What is Parameter Sniffing?
  • Plan Cache Limitations
  • Alternative Strategies

Module 9: Intermediate Execution Plan Analysis

  • Aggregation Operators
  • Blocking Operators
  • Estimation Quirks
  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.