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:
- Watch SQL videos on SQLMaestros YouTube channel or directly jump to our video lobby.
- Take a glance at SQLMaestros Corporate Services. Learn More.
Subscribe to SQLMaestros Newsletter | Access Past Newsletters
Leave A Comment