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