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