1. Урок 1.00:01:27
    An Introduction to This Course
  2. Урок 2.00:01:17
    The SQL Engine
  3. Урок 3.00:01:31
    The Query Processing Process
  4. Урок 4.00:01:45
    The Search Space
  5. Урок 5.00:01:33
    Whats In the Cost
  6. Урок 6.00:01:21
    Plan Cache Reuse
  7. Урок 7.00:00:52
    What Causes Recompilation
  8. Урок 8.00:04:03
    Terminology
  9. Урок 9.00:02:35
    Anatomy of Execution Plan
  10. Урок 10.00:01:38
    Execution Plan Output Options
  11. Урок 11.00:01:57
    Scan VS Seek
  12. Урок 12.00:02:10
    Scanning Demos
  13. Урок 13.00:03:07
    Seeking Demos
  14. Урок 14.00:04:09
    The Bookmark Lookup
  15. Урок 15.00:02:03
    Aggregations
  16. Урок 16.00:03:06
    Hash Match Operator
  17. Урок 17.00:01:55
    Joins - The Nested Loop
  18. Урок 18.00:01:26
    Joins - The Merge Join
  19. Урок 19.00:01:18
    Joins - The Hash Join
  20. Урок 20.00:01:14
    Parallelism Introduction
  21. Урок 21.00:01:36
    Statistics Contain 3 Key Pieces of Information in DBCC SHOW_STATISTICS
  22. Урок 22.00:04:25
    Anatomy of a Statistic HeaderVector and Histogram
  23. Урок 23.00:01:18
    Out of Date Statistics
  24. Урок 24.00:01:17
    Stale Statistics Demo
  25. Урок 25.00:01:26
    Maintaining Statistics
  26. Урок 26.00:04:36
    Setting Up Statistics Maintenance Job
  27. Урок 27.00:03:24
    The Scan On Large Tables
  28. Урок 28.00:02:47
    Using SET STATISTICS IO ON
  29. Урок 29.00:02:45
    Non-Clustered Indexes on Heaps
  30. Урок 30.00:03:30
    The No Good Sort Operator
  31. Урок 31.00:02:00
    Unwinding The Spool