SQL Server Optimizing Stored Procedure Performance | 734FE2DA5EFD335A3952F9D5663A5D768E4D6CD4

SQL Server Optimizing Stored Procedure Performance

Name	SQL Server Optimizing Stored Procedure Performance	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.9 GB
Total Files	93
Hash	734FE2DA5EFD335A3952F9D5663A5D768E4D6CD4

/8. Optimization and Recompilation Section 4/
11. DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4	120.4 MB
05. DEMO Dynamic String Execution.mp4	67.6 MB
08. DEMO Multi-Purpose Procedures - Setup and Scenario.mp4	41.5 MB
09. DEMO Multi-Purpose Procedures - The Problem.mp4	33.6 MB
10. DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4	26.0 MB
07. Building Strings Dynamically and Caching.mp4	12.8 MB
04. Dynamic String Execution.mp4	9.8 MB
01. When Does a Procedure Get Optimized.mp4	9.5 MB
03. The Checkered Past of OPTION (RECOMPILE).mp4	9.3 MB
12. Patterns and Practices in Statement Recompilation.mp4	8.8 MB
06. Multi-Purpose Procedures.mp4	7.9 MB
02. Server-Wide OPTIMIZE FOR UNKNOWN.mp4	7.6 MB
13. Summary Stored Procedure PitfallsPerformance.mp4	1.6 MB
/5. Optimization and Recompilation Section 1/
04. DEMO Long Blocking Chains.mp4	88.8 MB
08. DEMO Conditional Logic - Part 1.mp4	57.8 MB
06. DEMO CREATE ... WITH RECOMPILE.mp4	39.5 MB
10. DEMO Conditional Logic - Part 2 - Modularization.mp4	38.3 MB
03. sp_recompile object_name.mp4	20.1 MB
02. Options for Recompilation.mp4	10.9 MB
09. Modularization.mp4	9.4 MB
01. Overview.mp4	9.0 MB
05. CREATE ... WITH RECOMPILE.mp4	8.8 MB
07. Conditional Logic.mp4	7.7 MB
/3. Creation, Compilation, and Invalidation Section 1/
06. Stored Procedure Plans and Caching.mp4	84.9 MB
08. Side Effect Plan Cache Flush (2).mp4	48.2 MB
05. Creating Stored Procedures.mp4	43.0 MB
04. Where Are Stored Procedures Stored (2).mp4	26.6 MB
07. Side Effect Plan Cache Flush (1).mp4	18.1 MB
12. DEMO Setup Credit Sample Database.mp4	11.4 MB
03. Where Are Stored Procedures Stored (1).mp4	9.1 MB
15. DEMO Database-Level Invalidation or Eviction.mp4	7.5 MB
16. DEMO Server-Level Invalidation or Eviction.mp4	6.7 MB
02. What Happens When You Create a Procedure.mp4	6.3 MB
11. DEMO Generic Demo Intro.mp4	5.1 MB
13. DEMO Setup Analysis Procedures for Credit.mp4	5.0 MB
10. Side Effect Plan Cache Flush (4).mp4	4.1 MB
09. Side Effect Plan Cache Flush (3).mp4	3.8 MB
01. Overview.mp4	3.6 MB
14. DEMO Object-Level Invalidation or Eviction.mp4	2.7 MB
/4. Creation, Compilation, and Invalidation Section 2/
03. DEMO Plan Invalidation and Statistics - Part 1.mp4	78.4 MB
05. DEMO Plan Invalidation and Statistics - Part 2.mp4	73.3 MB
01. Plan Invalidation.mp4	11.4 MB
02. Plan Invalidation Due to Statistics Updates.mp4	8.7 MB
08. When Should You Recompile.mp4	7.8 MB
07. Stored Procedure Caching + Compilation Concerns.mp4	7.3 MB
04. Updates to Statistics may not Invalidate Bad Plans.mp4	7.0 MB
09. Summary Creation and Compilation.mp4	6.3 MB
06. Plan Invalidation Recompilation Causes.mp4	6.2 MB
/6. Optimization and Recompilation Section 2/
02. DEMO EXECUTE WITH RECOMPILE For Testing.mp4	75.2 MB
04. DEMO Determining Plan Stability.mp4	63.9 MB
08. DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4	62.4 MB
06. DEMO Recompilation With OPTION (RECOMPILE).mp4	35.2 MB
07. DEMO Recompilation With OPTION (Optimize For Literal).mp4	33.0 MB
09. DEMO Variables Simulate Optimize For UNKNOWN.mp4	18.4 MB
05. Statement-Level Recompilation.mp4	14.7 MB
03. EXECUTE WITH RECOMPILE (2).mp4	9.6 MB
01. EXECUTE WITH RECOMPILE (1).mp4	8.6 MB
/7. Optimization and Recompilation Section 3/
09. DEMO Stabilizing Plans With Indexes - Plan Stability.mp4	55.3 MB
10. DEMO Stabilizing Plans With Indexes - Voila!.mp4	54.6 MB
06. DEMO Scenario - EXEC With RECOMPILE.mp4	36.9 MB
07. DEMO Scenario - Conditional Logic Plus Modularization WORKS!.mp4	33.4 MB
04. DEMO Scenario - Scenario Explained.mp4	31.3 MB
05. DEMO Scenario - Conditional Logic Does NOT Work.mp4	29.7 MB
03. DEMO Scenario - Setup.mp4	27.2 MB
08. DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4	25.4 MB
02. OPTIMIZE FOR ....mp4	10.1 MB
01. OPTION (RECOMPILE).mp4	8.1 MB
12. Summary Walkthrough Demo (2).mp4	6.4 MB
11. Summary Walkthrough Demo (1).mp4	5.2 MB
/9. Other Concerns and Considerations/
03. Secondary Concerns and Considerations.mp4	14.7 MB
05. Just the Tip of the Iceberg.mp4	8.4 MB
01. Overview.mp4	5.6 MB
02. Demystifying Plan Caching for Bad Plans.mp4	5.5 MB
04. Optimizing Statement and Procedure Performance.mp4	5.4 MB
06. Course Summary.mp4	2.7 MB
/2. Why Use Stored Procedures/
06. Reducing Plan Cache Pollution.mp4	9.3 MB
04. Some Statements Can Be Cached for Reuse (2).mp4	8.1 MB
10. Summary Why Use Stored Procedures.mp4	6.9 MB
07. Understanding sp_executesql.mp4	5.7 MB
08. Stored Procedures sp_executesql and the Cache.mp4	5.5 MB
02. Different Ways to Execute SQL Statements.mp4	5.0 MB
09. Parameter Sniffing.mp4	4.0 MB
03. Some Statements Can Be Cached for Reuse (1).mp4	3.9 MB
01. Overview.mp4	3.2 MB
05. Version-Specific Plan Caching Whitepapers.mp4	2.3 MB
/1. Introduction/
05. What Does Optimizing Stored Procedure Performance NOT Mean.mp4	7.3 MB
03. What Does Optimizing Stored Procedure Performance Mean.mp4	6.0 MB
06. Why This Course Is Relevant.mp4	5.8 MB
01. Introduction.mp4	5.3 MB
02. This Course.mp4	4.9 MB
08. Course Focus and Structure (2).mp4	4.7 MB
04. Does This Sound Familiar.mp4	4.4 MB
07. Course Focus and Structure (1).mp4	4.2 MB
Total files 93