589689.xyz

SQL Server - Query Plan Analysis

  • 收录时间:2018-03-15 05:28:37
  • 文件大小:374MB
  • 下载次数:94
  • 最近下载:2021-01-12 22:38:08
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 02.Capturing Query Execution Plans/03.Demo - Capturing a Plan.wmv 22MB
  2. 03.Interpreting Query Execution Plans/06.Demo - Operator Cost.wmv 20MB
  3. 02.Capturing Query Execution Plans/10.Demo - Graphical Showplan.wmv 18MB
  4. 02.Capturing Query Execution Plans/14.Demo - Estimated vs. Actual.wmv 17MB
  5. 04.Common Operators/16.Demo - Hash Match Join.wmv 15MB
  6. 05.Noteworthy Patterns/25.Demo - Parameter Sniffing.wmv 15MB
  7. 05.Noteworthy Patterns/21.Demo - PlanAffectingConvert.wmv 13MB
  8. 03.Interpreting Query Execution Plans/09.Demo - Operator Memory.wmv 13MB
  9. 04.Common Operators/12.Demo - Nested Loop.wmv 12MB
  10. 05.Noteworthy Patterns/09.Demo - Hash Join Spills.wmv 12MB
  11. 04.Common Operators/18.Demo - Filter.wmv 10MB
  12. 05.Noteworthy Patterns/17.Demo - Data Modification Plan Patterns.wmv 9MB
  13. 02.Capturing Query Execution Plans/08.Demo - Using Extended Events to Capture Execution Plans.wmv 9MB
  14. 04.Common Operators/05.Demo - Index Seeks.wmv 8MB
  15. 05.Noteworthy Patterns/07.Demo - Merge Join Overhead.wmv 8MB
  16. 04.Common Operators/24.Demo - Sort.wmv 8MB
  17. 04.Common Operators/07.Demo - Lookups.wmv 7MB
  18. 02.Capturing Query Execution Plans/12.Demo - SQL Sentry Plan Explorer.wmv 7MB
  19. 04.Common Operators/44.Demo - Segment and Sequence Project.wmv 7MB
  20. 02.Capturing Query Execution Plans/06.Demo - DMOs.wmv 7MB
  21. 04.Common Operators/31.Demo - Assert.wmv 6MB
  22. 05.Noteworthy Patterns/03.Demo - Missing index warnings.wmv 6MB
  23. 04.Common Operators/40.Demo - Merge Interval.wmv 6MB
  24. 04.Common Operators/36.Demo - Exchange Operators.wmv 5MB
  25. 04.Common Operators/29.Demo - Constant Scan.wmv 5MB
  26. 04.Common Operators/22.Demo - Hash Match Aggregate.wmv 5MB
  27. 04.Common Operators/20.Demo - Stream Aggregate.wmv 5MB
  28. 04.Common Operators/42.Demo - Concatenation.wmv 4MB
  29. 04.Common Operators/38.Demo - Bitmap.wmv 4MB
  30. 04.Common Operators/03.Demo - Table and Index Scans.wmv 4MB
  31. 04.Common Operators/27.Demo - Eager Spool.wmv 4MB
  32. 04.Common Operators/14.Demo - Merge Join.wmv 4MB
  33. 04.Common Operators/33.Demo - Compute Scalar.wmv 3MB
  34. 04.Common Operators/09.Outer - Inner Terminology.wmv 2MB
  35. 04.Common Operators/10.Demo - Outer-Inner Terminology.wmv 2MB
  36. 04.Common Operators/26.Eager Spool and 'Halloween Protection'.wmv 2MB
  37. 02.Capturing Query Execution Plans/02.Capturing a Plan.wmv 2MB
  38. 02.Capturing Query Execution Plans/13.Estimated vs. Actual.wmv 2MB
  39. 04.Common Operators/08.Join Considerations.wmv 2MB
  40. 05.Noteworthy Patterns/02.The 'Basics'.wmv 2MB
  41. 05.Noteworthy Patterns/05.Nested Loop Patterns.wmv 2MB
  42. 02.Capturing Query Execution Plans/05.DMOs.wmv 2MB
  43. 04.Common Operators/06.Lookups.wmv 2MB
  44. 02.Capturing Query Execution Plans/09.Graphical Showplan.wmv 2MB
  45. 01.Course Introduction/02.Why Do We Care About QPs.wmv 2MB
  46. 03.Interpreting Query Execution Plans/08.Operator Memory (2).wmv 2MB
  47. 01.Course Introduction/03.What Doesn't a Query Plan Tell Us.wmv 2MB
  48. 04.Common Operators/02.Table and Index Scans.wmv 2MB
  49. 01.Course Introduction/01.Course Introduction.wmv 2MB
  50. 05.Noteworthy Patterns/24.Parameter Sniffing.wmv 1MB
  51. 03.Interpreting Query Execution Plans/02.Iterators - Operators.wmv 1MB
  52. 05.Noteworthy Patterns/27.Course Summary.wmv 1MB
  53. 04.Common Operators/15.Hash Match Join.wmv 1MB
  54. 04.Common Operators/25.Spools.wmv 1MB
  55. 05.Noteworthy Patterns/11.Sort Patterns.wmv 1MB
  56. 04.Common Operators/01.Module Introduction.wmv 1MB
  57. 05.Noteworthy Patterns/26.Columnstore Index Execution Mode.wmv 1MB
  58. 04.Common Operators/17.Filter.wmv 1MB
  59. 05.Noteworthy Patterns/19.Data Type Conversions.wmv 1MB
  60. 04.Common Operators/13.Merge Join.wmv 1MB
  61. 02.Capturing Query Execution Plans/04.Why Deprecate.wmv 1MB
  62. 05.Noteworthy Patterns/08.Hash Join Patterns.wmv 1MB
  63. 04.Common Operators/11.Nested Loop.wmv 1MB
  64. 05.Noteworthy Patterns/01.Module Introduction.wmv 1MB
  65. 03.Interpreting Query Execution Plans/01.Module Introduction.wmv 1MB
  66. 05.Noteworthy Patterns/14.Spool Overhead.wmv 1MB
  67. 03.Interpreting Query Execution Plans/07.Operator Memory (1).wmv 1MB
  68. 05.Noteworthy Patterns/04.Lookups.wmv 1MB
  69. 05.Noteworthy Patterns/06.Merge Join Patterns.wmv 1MB
  70. 05.Noteworthy Patterns/23.ColumnsWithNoStatistics Warning.wmv 1MB
  71. 03.Interpreting Query Execution Plans/03.Query Tree.wmv 1MB
  72. 04.Common Operators/35.Exchange Operators.wmv 1MB
  73. 04.Common Operators/32.Compute Scalar.wmv 1MB
  74. 04.Common Operators/21.Hash Match (Aggregate).wmv 1009KB
  75. 04.Common Operators/19.Stream Aggregate.wmv 1000KB
  76. 05.Noteworthy Patterns/12.Aggregates.wmv 974KB
  77. 02.Capturing Query Execution Plans/11.SQL Sentry Plan Explorer.wmv 956KB
  78. 02.Capturing Query Execution Plans/07.SQL Trace and Extended Events.wmv 915KB
  79. 03.Interpreting Query Execution Plans/04.Operator Cost (1).wmv 897KB
  80. 02.Capturing Query Execution Plans/01.Module Introduction.wmv 897KB
  81. 04.Common Operators/28.Constant Scan.wmv 833KB
  82. 03.Interpreting Query Execution Plans/05.Operator Cost (2).wmv 827KB
  83. 05.Noteworthy Patterns/10.Stop-and-Go Operators.wmv 824KB
  84. 01.Course Introduction/04.Course Structure.wmv 792KB
  85. 05.Noteworthy Patterns/15.Parallelism Performance Aspects.wmv 777KB
  86. 05.Noteworthy Patterns/22.NoJoinPredicateWarning.wmv 765KB
  87. 04.Common Operators/43.Segment and Sequence Project.wmv 760KB
  88. 05.Noteworthy Patterns/13.Predicates.wmv 754KB
  89. 04.Common Operators/34.Identifying Parallelism in the Plan.wmv 713KB
  90. 05.Noteworthy Patterns/16.Data Modification Plan Patterns.wmv 713KB
  91. 05.Noteworthy Patterns/18.Cardinality Estimate Issues.wmv 707KB
  92. 04.Common Operators/04.Index Seeks.wmv 672KB
  93. 04.Common Operators/37.Bitmap.wmv 522KB
  94. 05.Noteworthy Patterns/20.PlanAffectingConvert.wmv 487KB
  95. 04.Common Operators/39.Merge Interval.wmv 425KB
  96. 04.Common Operators/30.Assert.wmv 402KB
  97. 04.Common Operators/41.Concatenation.wmv 264KB
  98. 04.Common Operators/23.Sort.wmv 997B