Hi There,

Trust you are doing well.

You will be happy to know that Master Class recording for SQL Server Query Tuning and Optimization is now available. Total duration: 28 hours. You can subscribe and get instant access. Learn more.

This 28-hour content is in-depth, comprehensive, demo-packed, and the learnings can be applied to production instantly. Explore more.

Modules:

  • SQL Server Execution Engine
  • Query Lifecycle
  • Plan Cache Internals
  • Query Optimizer & Execution Plan
  • Query Tuning Fundamentals
  • Fixing Implicit Conversion
  • Sargability
  • Rewriting Subqueries
  • OVER clause
  • Temp Tables vs Table Variables
  • Working with NULLs
  • Common Table Expression
  • Rewriting Scalar UDFs
  • TVFs Basics
  • TVFs with APPLY
  • Ranking Functions
  • Dealing with SORTs
  • Optimizing OR
  • Fixing Bookmark Lookups
  • Cardinality Fix
  • Pivoting
  • Stats
  • Aggregations
  • Joins
  • NOLOCK
  • INEQUALITY
  • Complex Expressions
  • Fuzzy String Matching
  • Things you may not know
  • Index Tuning – Index Basics
  • Index Tuning – Page Splits
  • Index Tuning – Fragmentation
  • Index Tuning – Dynamic Index Seek
  • Index Tuning – Index Union
  • Index Tuning – Index Intersection
  • Index Tuning – Fragmentation Part 2
  • Index Tuning – Indexing for AND & OR
  • Index Tuning – Index Aggregates
  • Index Tuning – Indexing for Joins
  • Index Tuning – SARGability
  • Index Tuning – Multi Column Seek
  • Index Tuning – Multi Column Indexes
  • Index Tuning – Missing and Unused Indexes
  • Index Tuning – Redundant Indexes
  • Index Tuning – Clustering Key Choices
  • Stored Procedures – Parameter Sniffing
  • Dynamic SQL
  • Waits and Queues – Introduction
  • Waits and Queues – PAGEIOLATCH
  • Waits and Queues – CXPACKET and PARALLELISM
  • Waits and Queues – RESOURCE SEMAPHORE
  • Waits and Queues – THREADPOOL
  • Waits and Queues – BUFFERLATCH
  • Waits and Queues – SOS_SCHEDULER_YIELD
  • Concurrency
  • Deadlocks
  • Waits and Queues – EXTENDED Events
  • Automatic Tuning
  • Intelligent Query Processing – Adaptive Joins
  • Intelligent Query Processing – Batch Mode On Row Store
  • Intelligent Query Processing – Interleaved Execution
  • Intelligent Query Processing – Memory Grant Feedback
  • Intelligent Query Processing – Scalar UDF Lining
  • Intelligent Query Processing – Table Variable Deferred Compilation

You can subscribe and get instant access. Learn more.

Happy SQL Learning.

PS: If you have a group of people and want this class to be delivered to your team members, just reply back to this email.

Regards
SQLMaestros Team

Additional stuff you might be interested in:

Subscribe to SQLMaestros Newsletter | Access Past Newsletters