1. Урок 1. 00:03:01
    Course Introduction
  2. Урок 2. 00:01:44
    Why Application Developers Should Understand SQL Performance
  3. Урок 3. 00:02:03
    What You Will Learn
  4. Урок 4. 00:02:26
    What Tools You Need
  5. Урок 5. 00:01:59
    Installing the Sample Database
  6. Урок 6. 00:04:22
    Table Concepts
  7. Урок 7. 00:02:57
    Index Concepts
  8. Урок 8. 00:01:12
    Summary
  9. Урок 9. 00:02:10
    Analyzing SQL Statements for Performance. Introduction
  10. Урок 10. 00:03:20
    Understanding How SQL Server Will Execute a SQL Statement
  11. Урок 11. 00:08:43
    Reading and Interpreting an Execution Plan for a SQL Statement
  12. Урок 12. 00:04:18
    Getting Execution Statistics for a SQL Statement
  13. Урок 13. 00:04:28
    Improving Statement Performance by Adding an Index
  14. Урок 14. 00:01:23
    Before and After Performance Comparison
  15. Урок 15. 00:05:06
    Rewriting SQL Statements for Improved Performance
  16. Урок 16. 00:04:32
    Common Execution Plan Operations
  17. Урок 17. 00:03:01
    Analyzing SQL Statements for Performance. Summary
  18. Урок 18. 00:01:30
    Building Effective Indexes. Introduction
  19. Урок 19. 00:02:26
    Index Terminology Refresher
  20. Урок 20. 00:03:33
    What Should I Index in My Database
  21. Урок 21. 00:04:35
    Why Index Column Order Matters
  22. Урок 22. 00:01:58
    Applying Index Column Order Rules
  23. Урок 23. 00:02:29
    Index Selectivity Explained
  24. Урок 24. 00:08:42
    Index Selectivity Examples
  25. Урок 25. 00:03:21
    LIKE Clauses and Index Selectivity
  26. Урок 26. 00:04:25
    How Functions in the WHERE Clause Affect Indexes
  27. Урок 27. 00:03:37
    Include Columns and Covering Indexes
  28. Урок 28. 00:03:14
    Over-indexing
  29. Урок 29. 00:02:26
    Interpreting SQL Server Index Recommendations
  30. Урок 30. 00:04:51
    Building Effective Indexes. Review
  31. Урок 31. 00:03:06
    Finding Performance Bottlenecks in SQL Server. Introduction
  32. Урок 32. 00:01:48
    Required Permissions for Querying Dynamic Management Views
  33. Урок 33. 00:02:48
    Getting Information About SQL Server Sessions and Resource Usage
  34. Урок 34. 00:04:59
    Finding What SQL Statements are Currently Executing
  35. Урок 35. 00:04:08
    Finding the Slowest, Most Expensive SQL Statements
  36. Урок 36. 00:04:31
    Getting SQL Server's Recommendations on Missing Indexes
  37. Урок 37. 00:03:40
    Finding Indexes That are Not Being Used
  38. Урок 38. 00:01:16
    Finding Performance Bottlenecks in SQL Server. Summary
  39. Урок 39. 00:05:01
    What is SQL Tracing and Why Developers Should Know About it
  40. Урок 40. 00:07:08
    Setting up a SQL Profiler Trace
  41. Урок 41. 00:04:06
    Running a SQL Profiler Trace
  42. Урок 42. 00:06:01
    Running a Trace as a Server Side Trace
  43. Урок 43. 00:02:56
    Introduction to Using Extended Events for SQL Tracing
  44. Урок 44. 00:08:26
    Setting up an Extended Events Trace Session
  45. Урок 45. 00:01:22
    Running an Extended Events Trace Session
  46. Урок 46. 00:01:39
    Configuring the Display Settings for Extended Events Data
  47. Урок 47. 00:05:50
    Analyzing Extended Events Trace Data
  48. Урок 48. 00:04:01
    Using Extended Events in SQL Azure
  49. Урок 49. 00:03:08
    Capturing What Your Application is Doing Inside SQL Server. Summary
  50. Урок 50. 00:01:16
    Applying Common Performance Practices. Introduction
  51. Урок 51. 00:04:45
    Use Parameterized SQL
  52. Урок 52. 00:02:24
    Are Stored Procedures Faster Than SQL in Application Code
  53. Урок 53. 00:03:15
    Commit Behavior and Performance
  54. Урок 54. 00:02:17
    Object Relational Mappers Just Generate SQL
  55. Урок 55. 00:05:02
    Solving the N+1 Selects Problem
  56. Урок 56. 00:02:36
    Applying Common Performance Practices. Summary