SQL Server Query Tuning & Optimization (Master Class Recordings)

Trainer(s): Amit Bansal
Provider: SQLMaestros
Duration: 28 Hours
Subtitles: No
Price: USD 319
Type: Master Class

  • SQL Server Execution Engine
  • Query Lifecycle
  • Plan Cache Internals
  • Query Optimizer & Execution Plan
  • Better TSQL – Query Tuning Fundamentals
  • Better TSQL – Fixing Implicit Conversion
  • Better TSQL – Sargability
  • Better TSQL – Rewriting Subqueries
  • Better TSQL – OVER clause
  • Better TSQL – Temp Tables vs Table Variables
  • Better TSQL – Working with NULLs
  • Better TSQL – Common Table Expression
  • Better TSQL – Rewriting Scalar UDFs
  • Better TSQL – TVFs Basics
  • Better TSQL – TVFs with APPLY
  • Better TSQL – Ranking Functions
  • Better TSQL – Dealing with SORTs
  • Better TSQL – Optimizing OR
  • Better TSQL – Fixing Bookmark Lookups
  • Better TSQL – Cardinality Fix
  • Better TSQL – Pivoting
  • Better TSQL – Stats
  • Better TSQL – Aggregations
  • Better TSQL – Joins
  • Better TSQL – NOLOCK
  • Better TSQL – INEQUALITY
  • Better TSQL – Complex Expressions
  • Better TSQL – Fuzzy String Matching
  • Better TSQL – 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