Name SQL Server Optimizing Stored Procedure Performance

File Type video

Size 1.79GB

UpdateDate 2024-11-2

hash *****2DA5EFD335A3952F9D5663A5D768E4D6CD

Hot 24

Files 8. Optimization and Recompilation Section 4/11. DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4 | 114.85MB 5. Optimization and Recompilation Section 1/04. DEMO Long Blocking Chains.mp4 | 84.67MB 3. Creation, Compilation, and Invalidation Section 1/06. Stored Procedure Plans and Caching.mp4 | 80.96MB 4. Creation, Compilation, and Invalidation Section 2/03. DEMO Plan Invalidation and Statistics - Part 1.mp4 | 74.76MB 6. Optimization and Recompilation Section 2/02. DEMO EXECUTE WITH RECOMPILE For Testing.mp4 | 71.72MB 4. Creation, Compilation, and Invalidation Section 2/05. DEMO Plan Invalidation and Statistics - Part 2.mp4 | 69.88MB 8. Optimization and Recompilation Section 4/05. DEMO Dynamic String Execution.mp4 | 64.43MB 6. Optimization and Recompilation Section 2/04. DEMO Determining Plan Stability.mp4 | 60.97MB 6. Optimization and Recompilation Section 2/08. DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4 | 59.49MB 5. Optimization and Recompilation Section 1/08. DEMO Conditional Logic - Part 1.mp4 | 55.11MB 7. Optimization and Recompilation Section 3/09. DEMO Stabilizing Plans With Indexes - Plan Stability.mp4 | 52.74MB 7. Optimization and Recompilation Section 3/10. DEMO Stabilizing Plans With Indexes - Voila!.mp4 | 52.05MB 3. Creation, Compilation, and Invalidation Section 1/08. Side Effect Plan Cache Flush (2).mp4 | 46.00MB 3. Creation, Compilation, and Invalidation Section 1/05. Creating Stored Procedures.mp4 | 40.96MB 8. Optimization and Recompilation Section 4/08. DEMO Multi-Purpose Procedures - Setup and Scenario.mp4 | 39.62MB 5. Optimization and Recompilation Section 1/06. DEMO CREATE ... WITH RECOMPILE.mp4 | 37.62MB 5. Optimization and Recompilation Section 1/10. DEMO Conditional Logic - Part 2 - Modularization.mp4 | 36.53MB 7. Optimization and Recompilation Section 3/06. DEMO Scenario - EXEC With RECOMPILE.mp4 | 35.20MB 6. Optimization and Recompilation Section 2/06. DEMO Recompilation With OPTION (RECOMPILE).mp4 | 33.53MB 8. Optimization and Recompilation Section 4/09. DEMO Multi-Purpose Procedures - The Problem.mp4 | 32.03MB 7. Optimization and Recompilation Section 3/07. DEMO Scenario - Conditional Logic Plus Modularization WORKS!.mp4 | 31.87MB 6. Optimization and Recompilation Section 2/07. DEMO Recompilation With OPTION (Optimize For Literal).mp4 | 31.47MB 7. Optimization and Recompilation Section 3/04. DEMO Scenario - Scenario Explained.mp4 | 29.80MB 7. Optimization and Recompilation Section 3/05. DEMO Scenario - Conditional Logic Does NOT Work.mp4 | 28.35MB 7. Optimization and Recompilation Section 3/03. DEMO Scenario - Setup.mp4 | 25.98MB 3. Creation, Compilation, and Invalidation Section 1/04. Where Are Stored Procedures Stored (2).mp4 | 25.32MB 8. Optimization and Recompilation Section 4/10. DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4 | 24.79MB 7. Optimization and Recompilation Section 3/08. DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4 | 24.26MB 5. Optimization and Recompilation Section 1/03. sp_recompile object_name.mp4 | 19.17MB 6. Optimization and Recompilation Section 2/09. DEMO Variables Simulate Optimize For UNKNOWN.mp4 | 17.59MB 3. Creation, Compilation, and Invalidation Section 1/07. Side Effect Plan Cache Flush (1).mp4 | 17.23MB 6. Optimization and Recompilation Section 2/05. Statement-Level Recompilation.mp4 | 13.99MB 9. Other Concerns and Considerations/03. Secondary Concerns and Considerations.mp4 | 13.98MB 8. Optimization and Recompilation Section 4/07. Building Strings Dynamically and Caching.mp4 | 12.24MB 3. Creation, Compilation, and Invalidation Section 1/12. DEMO Setup Credit Sample Database.mp4 | 10.88MB 4. Creation, Compilation, and Invalidation Section 2/01. Plan Invalidation.mp4 | 10.86MB 5. Optimization and Recompilation Section 1/02. Options for Recompilation.mp4 | 10.36MB 7. Optimization and Recompilation Section 3/02. OPTIMIZE FOR ....mp4 | 9.67MB 8. Optimization and Recompilation Section 4/04. Dynamic String Execution.mp4 | 9.37MB 6. Optimization and Recompilation Section 2/03. EXECUTE WITH RECOMPILE (2).mp4 | 9.20MB 8. Optimization and Recompilation Section 4/01. When Does a Procedure Get Optimized.mp4 | 9.06MB 5. Optimization and Recompilation Section 1/09. Modularization.mp4 | 8.99MB 8. Optimization and Recompilation Section 4/03. The Checkered Past of OPTION (RECOMPILE).mp4 | 8.87MB 2. Why Use Stored Procedures/06. Reducing Plan Cache Pollution.mp4 | 8.82MB 3. Creation, Compilation, and Invalidation Section 1/03. Where Are Stored Procedures Stored (1).mp4 | 8.65MB 5. Optimization and Recompilation Section 1/01. Overview.mp4 | 8.59MB 8. Optimization and Recompilation Section 4/12. Patterns and Practices in Statement Recompilation.mp4 | 8.38MB 5. Optimization and Recompilation Section 1/05. CREATE ... WITH RECOMPILE.mp4 | 8.36MB 4. Creation, Compilation, and Invalidation Section 2/02. Plan Invalidation Due to Statistics Updates.mp4 | 8.28MB 6. Optimization and Recompilation Section 2/01. EXECUTE WITH RECOMPILE (1).mp4 | 8.19MB 9. Other Concerns and Considerations/05. Just the Tip of the Iceberg.mp4 | 8.00MB 7. Optimization and Recompilation Section 3/01. OPTION (RECOMPILE).mp4 | 7.77MB 2. Why Use Stored Procedures/04. Some Statements Can Be Cached for Reuse (2).mp4 | 7.75MB 8. Optimization and Recompilation Section 4/06. Multi-Purpose Procedures.mp4 | 7.54MB 4. Creation, Compilation, and Invalidation Section 2/08. When Should You Recompile.mp4 | 7.47MB 5. Optimization and Recompilation Section 1/07. Conditional Logic.mp4 | 7.36MB 8. Optimization and Recompilation Section 4/02. Server-Wide OPTIMIZE FOR UNKNOWN.mp4 | 7.22MB 3. Creation, Compilation, and Invalidation Section 1/15. DEMO Database-Level Invalidation or Eviction.mp4 | 7.11MB 4. Creation, Compilation, and Invalidation Section 2/07. Stored Procedure Caching + Compilation Concerns.mp4 | 6.94MB 1. Introduction/05. What Does Optimizing Stored Procedure Performance NOT Mean.mp4 | 6.94MB 4. Creation, Compilation, and Invalidation Section 2/04. Updates to Statistics may not Invalidate Bad Plans.mp4 | 6.63MB 2. Why Use Stored Procedures/10. Summary Why Use Stored Procedures.mp4 | 6.57MB 3. Creation, Compilation, and Invalidation Section 1/16. DEMO Server-Level Invalidation or Eviction.mp4 | 6.35MB 7. Optimization and Recompilation Section 3/12. Summary Walkthrough Demo (2).mp4 | 6.09MB 3. Creation, Compilation, and Invalidation Section 1/02. What Happens When You Create a Procedure.mp4 | 6.05MB 4. Creation, Compilation, and Invalidation Section 2/09. Summary Creation and Compilation.mp4 | 5.96MB 4. Creation, Compilation, and Invalidation Section 2/06. Plan Invalidation Recompilation Causes.mp4 | 5.89MB 1. Introduction/03. What Does Optimizing Stored Procedure Performance Mean.mp4 | 5.74MB 1. Introduction/06. Why This Course Is Relevant.mp4 | 5.53MB 2. Why Use Stored Procedures/07. Understanding sp_executesql.mp4 | 5.40MB 9. Other Concerns and Considerations/01. Overview.mp4 | 5.36MB 2. Why Use Stored Procedures/08. Stored Procedures sp_executesql and the Cache.mp4 | 5.22MB 9. Other Concerns and Considerations/02. Demystifying Plan Caching for Bad Plans.mp4 | 5.20MB 9. Other Concerns and Considerations/04. Optimizing Statement and Procedure Performance.mp4 | 5.18MB 1. Introduction/01. Introduction.mp4 | 5.04MB 7. Optimization and Recompilation Section 3/11. Summary Walkthrough Demo (1).mp4 | 4.97MB 3. Creation, Compilation, and Invalidation Section 1/11. DEMO Generic Demo Intro.mp4 | 4.86MB 3. Creation, Compilation, and Invalidation Section 1/13. DEMO Setup Analysis Procedures for Credit.mp4 | 4.80MB 2. Why Use Stored Procedures/02. Different Ways to Execute SQL Statements.mp4 | 4.74MB 1. Introduction/02. This Course.mp4 | 4.63MB 1. Introduction/08. Course Focus and Structure (2).mp4 | 4.51MB 1. Introduction/04. Does This Sound Familiar.mp4 | 4.16MB 1. Introduction/07. Course Focus and Structure (1).mp4 | 4.03MB 3. Creation, Compilation, and Invalidation Section 1/10. Side Effect Plan Cache Flush (4).mp4 | 3.95MB 2. Why Use Stored Procedures/09. Parameter Sniffing.mp4 | 3.79MB 2. Why Use Stored Procedures/03. Some Statements Can Be Cached for Reuse (1).mp4 | 3.73MB 3. Creation, Compilation, and Invalidation Section 1/09. Side Effect Plan Cache Flush (3).mp4 | 3.66MB 3. Creation, Compilation, and Invalidation Section 1/01. Overview.mp4 | 3.43MB 2. Why Use Stored Procedures/01. Overview.mp4 | 3.01MB 9. Other Concerns and Considerations/06. Course Summary.mp4 | 2.61MB 3. Creation, Compilation, and Invalidation Section 1/14. DEMO Object-Level Invalidation or Eviction.mp4 | 2.59MB 2. Why Use Stored Procedures/05. Version-Specific Plan Caching Whitepapers.mp4 | 2.19MB 8. Optimization and Recompilation Section 4/13. Summary Stored Procedure PitfallsPerformance.mp4 | 1.56MB