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