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