589689.xyz

Pluralsight - SQL Server Optimizing Stored Procedure Performance

  • 收录时间:2018-02-27 05:44:18
  • 文件大小:2GB
  • 下载次数:173
  • 最近下载:2021-01-04 00:40:56
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 08 Optimization and Recompilation Section 4/0811 DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4 115MB
  2. 05 Optimization and Recompilation Section 1/0504 DEMO Long Blocking Chains.mp4 85MB
  3. 03 Creation, Compilation, and Invalidation Section 1/0306 Stored Procedure Plans and Caching.mp4 81MB
  4. 04 Creation, Compilation, and Invalidation Section 2/0403 DEMO Plan Invalidation and Statistics - Part 1.mp4 75MB
  5. 06 Optimization and Recompilation Section 2/0602 DEMO EXECUTE ... WITH RECOMPILE For Testing.mp4 72MB
  6. 04 Creation, Compilation, and Invalidation Section 2/0405 DEMO Plan Invalidation and Statistics - Part 2.mp4 70MB
  7. 08 Optimization and Recompilation Section 4/0805 DEMO Dynamic String Execution.mp4 64MB
  8. 06 Optimization and Recompilation Section 2/0604 DEMO Determining Plan Stability.mp4 61MB
  9. 06 Optimization and Recompilation Section 2/0608 DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4 59MB
  10. 05 Optimization and Recompilation Section 1/0508 DEMO Conditional Logic - Part 1.mp4 55MB
  11. 07 Optimization and Recompilation Section 3/0709 DEMO Stabilizing Plans With Indexes - Plan Stability.mp4 53MB
  12. 07 Optimization and Recompilation Section 3/0710 DEMO Stabilizing Plans With Indexes - Voila.mp4 52MB
  13. 03 Creation, Compilation, and Invalidation Section 1/0308 Side Effect Plan Cache Flush (2).mp4 46MB
  14. 03 Creation, Compilation, and Invalidation Section 1/0305 Creating Stored Procedures.mp4 41MB
  15. 08 Optimization and Recompilation Section 4/0808 DEMO Multi-Purpose Procedures - Setup and Scenario.mp4 40MB
  16. 05 Optimization and Recompilation Section 1/0506 DEMO CREATE ... WITH RECOMPILE.mp4 38MB
  17. 05 Optimization and Recompilation Section 1/0510 DEMO Conditional Logic - Part 2 - Modularization.mp4 37MB
  18. 07 Optimization and Recompilation Section 3/0706 DEMO Scenario - EXEC With RECOMPILE.mp4 35MB
  19. 06 Optimization and Recompilation Section 2/0606 DEMO Recompilation With OPTION (RECOMPILE).mp4 34MB
  20. 08 Optimization and Recompilation Section 4/0809 DEMO Multi-Purpose Procedures - The Problem.mp4 32MB
  21. 07 Optimization and Recompilation Section 3/0707 DEMO Scenario - Conditional Logic Plus Modularization WORKS.mp4 32MB
  22. 06 Optimization and Recompilation Section 2/0607 DEMO Recompilation With OPTION (Optimize For Literal).mp4 31MB
  23. 07 Optimization and Recompilation Section 3/0704 DEMO Scenario - Scenario Explained.mp4 30MB
  24. 07 Optimization and Recompilation Section 3/0705 DEMO Scenario - Conditional Logic Does NOT Work.mp4 28MB
  25. 07 Optimization and Recompilation Section 3/0703 DEMO Scenario - Setup.mp4 26MB
  26. 03 Creation, Compilation, and Invalidation Section 1/0304 Where Are Stored Procedures Stored (2).mp4 25MB
  27. 08 Optimization and Recompilation Section 4/0810 DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4 25MB
  28. 07 Optimization and Recompilation Section 3/0708 DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4 24MB
  29. 05 Optimization and Recompilation Section 1/0503 sp_recompile object_name.mp4 19MB
  30. 06 Optimization and Recompilation Section 2/0609 DEMO Variables Simulate Optimize For UNKNOWN.mp4 18MB
  31. 03 Creation, Compilation, and Invalidation Section 1/0307 Side Effect Plan Cache Flush (1).mp4 17MB
  32. 06 Optimization and Recompilation Section 2/0605 Statement-Level Recompilation.mp4 14MB
  33. 09 Other Concerns and Considerations/0903 Secondary Concerns and Considerations.mp4 14MB
  34. 08 Optimization and Recompilation Section 4/0807 Building Strings Dynamically and Caching.mp4 12MB
  35. 03 Creation, Compilation, and Invalidation Section 1/0312 DEMO Setup Credit Sample Database.mp4 11MB
  36. 04 Creation, Compilation, and Invalidation Section 2/0401 Plan Invalidation.mp4 11MB
  37. 05 Optimization and Recompilation Section 1/0502 Options for Recompilation.mp4 10MB
  38. 07 Optimization and Recompilation Section 3/0702 OPTIMIZE FOR ....mp4 10MB
  39. 08 Optimization and Recompilation Section 4/0804 Dynamic String Execution.mp4 9MB
  40. 06 Optimization and Recompilation Section 2/0603 EXECUTE ... WITH RECOMPILE (2).mp4 9MB
  41. 08 Optimization and Recompilation Section 4/0801 When Does a Procedure Get Optimized.mp4 9MB
  42. 05 Optimization and Recompilation Section 1/0509 Modularization.mp4 9MB
  43. 08 Optimization and Recompilation Section 4/0803 The Checkered Past of OPTION (RECOMPILE).mp4 9MB
  44. 02 Why Use Stored Procedures/0206 Reducing Plan Cache Pollution.mp4 9MB
  45. 03 Creation, Compilation, and Invalidation Section 1/0303 Where Are Stored Procedures Stored (1).mp4 9MB
  46. 05 Optimization and Recompilation Section 1/0501 Overview.mp4 9MB
  47. 08 Optimization and Recompilation Section 4/0812 Patterns and Practices in Statement Recompilation.mp4 8MB
  48. 05 Optimization and Recompilation Section 1/0505 CREATE ... WITH RECOMPILE.mp4 8MB
  49. 04 Creation, Compilation, and Invalidation Section 2/0402 Plan Invalidation Due to Statistics Updates.mp4 8MB
  50. 06 Optimization and Recompilation Section 2/0601 EXECUTE ... WITH RECOMPILE (1).mp4 8MB
  51. 09 Other Concerns and Considerations/0905 Just the Tip of the Iceberg.mp4 8MB
  52. 07 Optimization and Recompilation Section 3/0701 OPTION (RECOMPILE).mp4 8MB
  53. 02 Why Use Stored Procedures/0204 Some Statements Can Be Cached for Reuse (2).mp4 8MB
  54. 08 Optimization and Recompilation Section 4/0806 Multi-Purpose Procedures.mp4 8MB
  55. 04 Creation, Compilation, and Invalidation Section 2/0408 When Should You Recompile.mp4 7MB
  56. 05 Optimization and Recompilation Section 1/0507 Conditional Logic.mp4 7MB
  57. 08 Optimization and Recompilation Section 4/0802 Server-Wide OPTIMIZE FOR UNKNOWN.mp4 7MB
  58. 03 Creation, Compilation, and Invalidation Section 1/0315 DEMO Database-Level Invalidation or Eviction.mp4 7MB
  59. 04 Creation, Compilation, and Invalidation Section 2/0407 Stored Procedure Caching + Compilation Concerns.mp4 7MB
  60. 01 Introduction/0105 What Does Optimizing Stored Procedure Performance NOT Mean.mp4 7MB
  61. 04 Creation, Compilation, and Invalidation Section 2/0404 Updates to Statistics may not Invalidate Bad Plans.mp4 7MB
  62. 02 Why Use Stored Procedures/0210 Summary Why Use Stored Procedures.mp4 7MB
  63. 03 Creation, Compilation, and Invalidation Section 1/0316 DEMO Server-Level Invalidation or Eviction.mp4 6MB
  64. 07 Optimization and Recompilation Section 3/0712 Summary Walkthrough Demo (2).mp4 6MB
  65. 03 Creation, Compilation, and Invalidation Section 1/0302 What Happens When You Create a Procedure.mp4 6MB
  66. 04 Creation, Compilation, and Invalidation Section 2/0409 Summary Creation and Compilation.mp4 6MB
  67. 04 Creation, Compilation, and Invalidation Section 2/0406 Plan Invalidation Recompilation Causes.mp4 6MB
  68. 01 Introduction/0103 What Does Optimizing Stored Procedure Performance Mean.mp4 6MB
  69. 01 Introduction/0106 Why This Course Is Relevant.mp4 6MB
  70. 02 Why Use Stored Procedures/0207 Understanding sp_executesql.mp4 5MB
  71. 09 Other Concerns and Considerations/0901 Overview.mp4 5MB
  72. 02 Why Use Stored Procedures/0208 Stored Procedures sp_executesql and the Cache.mp4 5MB
  73. 09 Other Concerns and Considerations/0902 Demystifying Plan Caching for Bad Plans.mp4 5MB
  74. 09 Other Concerns and Considerations/0904 Optimizing Statement and Procedure Performance.mp4 5MB
  75. 01 Introduction/0101 Introduction.mp4 5MB
  76. 07 Optimization and Recompilation Section 3/0711 Summary Walkthrough Demo (1).mp4 5MB
  77. 03 Creation, Compilation, and Invalidation Section 1/0311 DEMO Generic Demo Intro.mp4 5MB
  78. 03 Creation, Compilation, and Invalidation Section 1/0313 DEMO Setup Analysis Procedures for Credit.mp4 5MB
  79. 02 Why Use Stored Procedures/0202 Different Ways to Execute SQL Statements.mp4 5MB
  80. 01 Introduction/0102 This Course.mp4 5MB
  81. 01 Introduction/0108 Course Focus and Structure (2).mp4 5MB
  82. 01 Introduction/0104 Does This Sound Familiar.mp4 4MB
  83. 01 Introduction/0107 Course Focus and Structure (1).mp4 4MB
  84. 03 Creation, Compilation, and Invalidation Section 1/0310 Side Effect Plan Cache Flush (4).mp4 4MB
  85. 02 Why Use Stored Procedures/0209 Parameter Sniffing.mp4 4MB
  86. 02 Why Use Stored Procedures/0203 Some Statements Can Be Cached for Reuse (1).mp4 4MB
  87. 03 Creation, Compilation, and Invalidation Section 1/0309 Side Effect Plan Cache Flush (3).mp4 4MB
  88. 03 Creation, Compilation, and Invalidation Section 1/0301 Overview.mp4 3MB
  89. 02 Why Use Stored Procedures/0201 Overview.mp4 3MB
  90. 09 Other Concerns and Considerations/0906 Course Summary.mp4 3MB
  91. 03 Creation, Compilation, and Invalidation Section 1/0314 DEMO Object-Level Invalidation or Eviction.mp4 3MB
  92. 02 Why Use Stored Procedures/0205 Version-Specific Plan Caching Whitepapers.mp4 2MB
  93. 08 Optimization and Recompilation Section 4/0813 Summary Stored Procedure Pitfalls-Performance.mp4 2MB