SQL Server Query Tuning & Optimization

* Including GST + Internet Transaction Fee

* Group discounts available (write to classes@SQLMaestros.com)

* Prices are subject to change without prior notice

• On-demand lifetime streaming access.
• Most critical topics covered.
• 28 hours of deep practical content.
• True level 200-300 content.
• Gain real-world knowledge, get real-world exposure.
• Get your own copy of SQLMaestros course material + Scripts.
• Packed with real-world demos and examples.
• Apply your learning into production right away.
• Practice Labs/Demos at your own pace

1. SQL Server Execution Engine
2. Query Lifecycle
3. Plan Cache Internals
4. Query Optimizer & Execution Plan
5. Better TSQL – Query Tuning Fundamentals
6. Better TSQL – Fixing Implicit Conversion
7. Better TSQL – Sargability
8. Better TSQL – Rewriting Subqueries
9. Better TSQL – OVER clause
10. Better TSQL – Temp Tables vs Table Variables
11. Better TSQL – Working with NULLs
12. Better TSQL – Common Table Expression
13. Better TSQL – Rewriting Scalar UDFs
14. Better TSQL – TVFs Basics
15. Better TSQL – TVFs with APPLY
16. Better TSQL – Ranking Functions
17. Better TSQL – Dealing with SORTs
18. Better TSQL – Optimizing OR
19. Better TSQL – Fixing Bookmark Lookups
20. Better TSQL – Cardinality Fix
21. Better TSQL – Pivoting
22. Better TSQL – Stats
23. Better TSQL – Aggregations
24. Better TSQL – Joins
25. Better TSQL – NOLOCK
26. Better TSQL – INEQUALITY
27. Better TSQL – Complex Expressions
28. Better TSQL – Fuzzy String Matching
29. Better TSQL – Things you may not know
30. Index Tuning – Index Basics
31. Index Tuning – Page Splits
32. Index Tuning – Fragmentation
33. Index Tuning – Dynamic Index Seek
34. Index Tuning – Index Union
35. Index Tuning – Index Intersection
36. Index Tuning – Fragmentation Part 2
37. Index Tuning – Indexing for AND & OR
38. Index Tuning – Index Aggregates
39. Index Tuning – Indexing for Joins
40. Index Tuning – SARGability
41. Index Tuning – Multi Column Seek
42. Index Tuning – Multi Column Indexes
43. Index Tuning – Missing and Unused Indexes
44. Index Tuning – Redundant Indexes
45. Index Tuning – Clustering Key Choices
46. Stored Procedures – Parameter Sniffing
47. Dynamic SQL
48. Waits and Queues – Introduction
49. Waits and Queues – PAGEIOLATCH
50. Waits and Queues – CXPACKET and PARALLELISM
51. Waits and Queues – RESOURCE SEMAPHORE
52. Waits and Queues – THREADPOOL
53. Waits and Queues – BUFFERLATCH
54. Waits and Queues – SOS_SCHEDULER_YIELD
55. Concurrency
56. Deadlocks
57. Waits and Queues – EXTENDED Events
58. Automatic Tuning
59. Intelligent Query Processing – Adaptive Joins
60. Intelligent Query Processing – Batch Mode On Row Store
61. Intelligent Query Processing – Interleaved Execution
62. Intelligent Query Processing – Memory Grant Feedback
63. Intelligent Query Processing – Scalar UDF Lining
64. Intelligent Query Processing – Table Variable Deferred Compilation