Удален по просьбе правообладателя
  1. Урок 1.00:03:02
    Course Introduction
  2. Урок 2.00:01:45
    Why Application Developers Should Understand SQL Performance
  3. Урок 3.00:02:04
    What You Will Learn
  4. Урок 4.00:02:27
    What Tools You Need
  5. Урок 5.00:02:00
    Installing the Sample Database
  6. Урок 6.00:04:23
    Table Concepts
  7. Урок 7.00:02:58
    Index Concepts
  8. Урок 8.00:01:13
    Summary
  9. Урок 9.00:02:11
    Analyzing SQL Statements for Performance. Introduction
  10. Урок 10.00:03:21
    Understanding How SQL Server Will Execute a SQL Statement
  11. Урок 11.00:08:44
    Reading and Interpreting an Execution Plan for a SQL Statement
  12. Урок 12.00:04:19
    Getting Execution Statistics for a SQL Statement
  13. Урок 13.00:04:29
    Improving Statement Performance by Adding an Index
  14. Урок 14.00:01:24
    Before and After Performance Comparison
  15. Урок 15.00:05:07
    Rewriting SQL Statements for Improved Performance
  16. Урок 16.00:04:33
    Common Execution Plan Operations
  17. Урок 17.00:03:02
    Analyzing SQL Statements for Performance. Summary
  18. Урок 18.00:01:31
    Building Effective Indexes. Introduction
  19. Урок 19.00:02:27
    Index Terminology Refresher
  20. Урок 20.00:03:34
    What Should I Index in My Database
  21. Урок 21.00:04:36
    Why Index Column Order Matters
  22. Урок 22.00:01:59
    Applying Index Column Order Rules
  23. Урок 23.00:02:30
    Index Selectivity Explained
  24. Урок 24.00:08:43
    Index Selectivity Examples
  25. Урок 25.00:03:22
    LIKE Clauses and Index Selectivity
  26. Урок 26.00:04:26
    How Functions in the WHERE Clause Affect Indexes
  27. Урок 27.00:03:38
    Include Columns and Covering Indexes
  28. Урок 28.00:03:15
    Over-indexing
  29. Урок 29.00:02:27
    Interpreting SQL Server Index Recommendations
  30. Урок 30.00:04:52
    Building Effective Indexes. Review
  31. Урок 31.00:03:07
    Finding Performance Bottlenecks in SQL Server. Introduction
  32. Урок 32.00:01:49
    Required Permissions for Querying Dynamic Management Views
  33. Урок 33.00:02:49
    Getting Information About SQL Server Sessions and Resource Usage
  34. Урок 34.00:05:00
    Finding What SQL Statements are Currently Executing
  35. Урок 35.00:04:09
    Finding the Slowest Most Expensive SQL Statements
  36. Урок 36.00:04:32
    Getting SQL Server's Recommendations on Missing Indexes
  37. Урок 37.00:03:41
    Finding Indexes That are Not Being Used
  38. Урок 38.00:01:17
    Finding Performance Bottlenecks in SQL Server. Summary
  39. Урок 39.00:05:02
    What is SQL Tracing and Why Developers Should Know About it
  40. Урок 40.00:07:09
    Setting up a SQL Profiler Trace
  41. Урок 41.00:04:07
    Running a SQL Profiler Trace
  42. Урок 42.00:06:02
    Running a Trace as a Server Side Trace
  43. Урок 43.00:02:57
    Introduction to Using Extended Events for SQL Tracing
  44. Урок 44.00:08:27
    Setting up an Extended Events Trace Session
  45. Урок 45.00:01:23
    Running an Extended Events Trace Session
  46. Урок 46.00:01:40
    Configuring the Display Settings for Extended Events Data
  47. Урок 47.00:05:51
    Analyzing Extended Events Trace Data
  48. Урок 48.00:04:02
    Using Extended Events in SQL Azure
  49. Урок 49.00:03:09
    Capturing What Your Application is Doing Inside SQL Server. Summary
  50. Урок 50.00:01:17
    Applying Common Performance Practices. Introduction
  51. Урок 51.00:04:46
    Use Parameterized SQL
  52. Урок 52.00:02:25
    Are Stored Procedures Faster Than SQL in Application Code
  53. Урок 53.00:03:16
    Commit Behavior and Performance
  54. Урок 54.00:02:18
    Object Relational Mappers Just Generate SQL
  55. Урок 55.00:05:03
    Solving the N+1 Selects Problem
  56. Урок 56.00:02:37
    Applying Common Performance Practices. Summary