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