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