Удален по просьбе правообладателя
  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