Use HAPPY60 coupon code to get 60% off
New price: USD 319
* GST + Internet Transaction Fee additional
- 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
Reviews
There are no reviews yet.