589689.xyz

SQL Server Optimizing Stored Procedure Performance

  • 收录时间:2018-02-28 18:16:22
  • 文件大小:2GB
  • 下载次数:141
  • 最近下载:2021-01-13 17:41:14
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 8. Optimization and Recompilation Section 4/11. DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4 115MB
  2. 5. Optimization and Recompilation Section 1/04. DEMO Long Blocking Chains.mp4 85MB
  3. 3. Creation, Compilation, and Invalidation Section 1/06. Stored Procedure Plans and Caching.mp4 81MB
  4. 4. Creation, Compilation, and Invalidation Section 2/03. DEMO Plan Invalidation and Statistics - Part 1.mp4 75MB
  5. 6. Optimization and Recompilation Section 2/02. DEMO EXECUTE WITH RECOMPILE For Testing.mp4 72MB
  6. 4. Creation, Compilation, and Invalidation Section 2/05. DEMO Plan Invalidation and Statistics - Part 2.mp4 70MB
  7. 8. Optimization and Recompilation Section 4/05. DEMO Dynamic String Execution.mp4 64MB
  8. 6. Optimization and Recompilation Section 2/04. DEMO Determining Plan Stability.mp4 61MB
  9. 6. Optimization and Recompilation Section 2/08. DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4 59MB
  10. 5. Optimization and Recompilation Section 1/08. DEMO Conditional Logic - Part 1.mp4 55MB
  11. 7. Optimization and Recompilation Section 3/09. DEMO Stabilizing Plans With Indexes - Plan Stability.mp4 53MB
  12. 7. Optimization and Recompilation Section 3/10. DEMO Stabilizing Plans With Indexes - Voila!.mp4 52MB
  13. 3. Creation, Compilation, and Invalidation Section 1/08. Side Effect Plan Cache Flush (2).mp4 46MB
  14. 3. Creation, Compilation, and Invalidation Section 1/05. Creating Stored Procedures.mp4 41MB
  15. 8. Optimization and Recompilation Section 4/08. DEMO Multi-Purpose Procedures - Setup and Scenario.mp4 40MB
  16. 5. Optimization and Recompilation Section 1/06. DEMO CREATE ... WITH RECOMPILE.mp4 38MB
  17. 5. Optimization and Recompilation Section 1/10. DEMO Conditional Logic - Part 2 - Modularization.mp4 37MB
  18. 7. Optimization and Recompilation Section 3/06. DEMO Scenario - EXEC With RECOMPILE.mp4 35MB
  19. 6. Optimization and Recompilation Section 2/06. DEMO Recompilation With OPTION (RECOMPILE).mp4 34MB
  20. 8. Optimization and Recompilation Section 4/09. DEMO Multi-Purpose Procedures - The Problem.mp4 32MB
  21. 7. Optimization and Recompilation Section 3/07. DEMO Scenario - Conditional Logic Plus Modularization WORKS!.mp4 32MB
  22. 6. Optimization and Recompilation Section 2/07. DEMO Recompilation With OPTION (Optimize For Literal).mp4 31MB
  23. 7. Optimization and Recompilation Section 3/04. DEMO Scenario - Scenario Explained.mp4 30MB
  24. 7. Optimization and Recompilation Section 3/05. DEMO Scenario - Conditional Logic Does NOT Work.mp4 28MB
  25. 7. Optimization and Recompilation Section 3/03. DEMO Scenario - Setup.mp4 26MB
  26. 3. Creation, Compilation, and Invalidation Section 1/04. Where Are Stored Procedures Stored (2).mp4 25MB
  27. 8. Optimization and Recompilation Section 4/10. DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4 25MB
  28. 7. Optimization and Recompilation Section 3/08. DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4 24MB
  29. 5. Optimization and Recompilation Section 1/03. sp_recompile object_name.mp4 19MB
  30. 6. Optimization and Recompilation Section 2/09. DEMO Variables Simulate Optimize For UNKNOWN.mp4 18MB
  31. 3. Creation, Compilation, and Invalidation Section 1/07. Side Effect Plan Cache Flush (1).mp4 17MB
  32. 6. Optimization and Recompilation Section 2/05. Statement-Level Recompilation.mp4 14MB
  33. 9. Other Concerns and Considerations/03. Secondary Concerns and Considerations.mp4 14MB
  34. 8. Optimization and Recompilation Section 4/07. Building Strings Dynamically and Caching.mp4 12MB
  35. 3. Creation, Compilation, and Invalidation Section 1/12. DEMO Setup Credit Sample Database.mp4 11MB
  36. 4. Creation, Compilation, and Invalidation Section 2/01. Plan Invalidation.mp4 11MB
  37. 5. Optimization and Recompilation Section 1/02. Options for Recompilation.mp4 10MB
  38. 7. Optimization and Recompilation Section 3/02. OPTIMIZE FOR ....mp4 10MB
  39. 8. Optimization and Recompilation Section 4/04. Dynamic String Execution.mp4 9MB
  40. 6. Optimization and Recompilation Section 2/03. EXECUTE WITH RECOMPILE (2).mp4 9MB
  41. 8. Optimization and Recompilation Section 4/01. When Does a Procedure Get Optimized.mp4 9MB
  42. 5. Optimization and Recompilation Section 1/09. Modularization.mp4 9MB
  43. 8. Optimization and Recompilation Section 4/03. The Checkered Past of OPTION (RECOMPILE).mp4 9MB
  44. 2. Why Use Stored Procedures/06. Reducing Plan Cache Pollution.mp4 9MB
  45. 3. Creation, Compilation, and Invalidation Section 1/03. Where Are Stored Procedures Stored (1).mp4 9MB
  46. 5. Optimization and Recompilation Section 1/01. Overview.mp4 9MB
  47. 8. Optimization and Recompilation Section 4/12. Patterns and Practices in Statement Recompilation.mp4 8MB
  48. 5. Optimization and Recompilation Section 1/05. CREATE ... WITH RECOMPILE.mp4 8MB
  49. 4. Creation, Compilation, and Invalidation Section 2/02. Plan Invalidation Due to Statistics Updates.mp4 8MB
  50. 6. Optimization and Recompilation Section 2/01. EXECUTE WITH RECOMPILE (1).mp4 8MB
  51. 9. Other Concerns and Considerations/05. Just the Tip of the Iceberg.mp4 8MB
  52. 7. Optimization and Recompilation Section 3/01. OPTION (RECOMPILE).mp4 8MB
  53. 2. Why Use Stored Procedures/04. Some Statements Can Be Cached for Reuse (2).mp4 8MB
  54. 8. Optimization and Recompilation Section 4/06. Multi-Purpose Procedures.mp4 8MB
  55. 4. Creation, Compilation, and Invalidation Section 2/08. When Should You Recompile.mp4 7MB
  56. 5. Optimization and Recompilation Section 1/07. Conditional Logic.mp4 7MB
  57. 8. Optimization and Recompilation Section 4/02. Server-Wide OPTIMIZE FOR UNKNOWN.mp4 7MB
  58. 3. Creation, Compilation, and Invalidation Section 1/15. DEMO Database-Level Invalidation or Eviction.mp4 7MB
  59. 4. Creation, Compilation, and Invalidation Section 2/07. Stored Procedure Caching + Compilation Concerns.mp4 7MB
  60. 1. Introduction/05. What Does Optimizing Stored Procedure Performance NOT Mean.mp4 7MB
  61. 4. Creation, Compilation, and Invalidation Section 2/04. Updates to Statistics may not Invalidate Bad Plans.mp4 7MB
  62. 2. Why Use Stored Procedures/10. Summary Why Use Stored Procedures.mp4 7MB
  63. 3. Creation, Compilation, and Invalidation Section 1/16. DEMO Server-Level Invalidation or Eviction.mp4 6MB
  64. 7. Optimization and Recompilation Section 3/12. Summary Walkthrough Demo (2).mp4 6MB
  65. 3. Creation, Compilation, and Invalidation Section 1/02. What Happens When You Create a Procedure.mp4 6MB
  66. 4. Creation, Compilation, and Invalidation Section 2/09. Summary Creation and Compilation.mp4 6MB
  67. 4. Creation, Compilation, and Invalidation Section 2/06. Plan Invalidation Recompilation Causes.mp4 6MB
  68. 1. Introduction/03. What Does Optimizing Stored Procedure Performance Mean.mp4 6MB
  69. 1. Introduction/06. Why This Course Is Relevant.mp4 6MB
  70. 2. Why Use Stored Procedures/07. Understanding sp_executesql.mp4 5MB
  71. 9. Other Concerns and Considerations/01. Overview.mp4 5MB
  72. 2. Why Use Stored Procedures/08. Stored Procedures sp_executesql and the Cache.mp4 5MB
  73. 9. Other Concerns and Considerations/02. Demystifying Plan Caching for Bad Plans.mp4 5MB
  74. 9. Other Concerns and Considerations/04. Optimizing Statement and Procedure Performance.mp4 5MB
  75. 1. Introduction/01. Introduction.mp4 5MB
  76. 7. Optimization and Recompilation Section 3/11. Summary Walkthrough Demo (1).mp4 5MB
  77. 3. Creation, Compilation, and Invalidation Section 1/11. DEMO Generic Demo Intro.mp4 5MB
  78. 3. Creation, Compilation, and Invalidation Section 1/13. DEMO Setup Analysis Procedures for Credit.mp4 5MB
  79. 2. Why Use Stored Procedures/02. Different Ways to Execute SQL Statements.mp4 5MB
  80. 1. Introduction/02. This Course.mp4 5MB
  81. 1. Introduction/08. Course Focus and Structure (2).mp4 5MB
  82. 1. Introduction/04. Does This Sound Familiar.mp4 4MB
  83. 1. Introduction/07. Course Focus and Structure (1).mp4 4MB
  84. 3. Creation, Compilation, and Invalidation Section 1/10. Side Effect Plan Cache Flush (4).mp4 4MB
  85. 2. Why Use Stored Procedures/09. Parameter Sniffing.mp4 4MB
  86. 2. Why Use Stored Procedures/03. Some Statements Can Be Cached for Reuse (1).mp4 4MB
  87. 3. Creation, Compilation, and Invalidation Section 1/09. Side Effect Plan Cache Flush (3).mp4 4MB
  88. 3. Creation, Compilation, and Invalidation Section 1/01. Overview.mp4 3MB
  89. 2. Why Use Stored Procedures/01. Overview.mp4 3MB
  90. 9. Other Concerns and Considerations/06. Course Summary.mp4 3MB
  91. 3. Creation, Compilation, and Invalidation Section 1/14. DEMO Object-Level Invalidation or Eviction.mp4 3MB
  92. 2. Why Use Stored Procedures/05. Version-Specific Plan Caching Whitepapers.mp4 2MB
  93. 8. Optimization and Recompilation Section 4/13. Summary Stored Procedure PitfallsPerformance.mp4 2MB