Worth Corner, Crawley, RH10 7SL

T-SQL for Developers

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 Queries

  • Statistics
  • Parameter Sniffing
  • Parallelism
  • Intermediate Execution Plan Analysis

Course Modules

Module 1: Why Execution Plans?

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

Module 5: Statistics

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

Module 2: Indexing

  • Clustered Indexes
  • Non-Clustered Indexes
  • Key Columns vs Included Columns
  • Filtered Indexes and Gotchas

Module 6: Parallelism

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

Module 3: Optimizer Join Types

  • Loop Join
  • Merge Join
  • Hash Join
  • Adaptive Query Joins

Module 7: Cost Based Queries

  • Query Cost
  • Costing Pyramid
  • Concurrency Issues

Module 4: Memory Grants

  • Spills
  • Concurrency

Module 8: Parameter Sniffing

  • Plan Cache Limitations
  • Alternative Strategies

Module 9: Intermediate Execution Plan Analysis

  • Aggregation Operators
  • Blocking Operators
  • Estimation Quirks

Book Course

Sign up for email alerts

Stay current with our latest insights

© Copyright 2020 SQLTraining Ltd.