| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0101 Introduction.mp4 |
5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0102 This Course.mp4 |
4.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0103 What Does Optimizing Stored Procedure Performance Mean.mp4 |
5.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0104 Does This Sound Familiar.mp4 |
4.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0105 What Does Optimizing Stored Procedure Performance NOT Mean.mp4 |
6.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0106 Why This Course Is Relevant.mp4 |
5.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0107 Course Focus and Structure (1).mp4 |
4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/01 Introduction/0108 Course Focus and Structure (2).mp4 |
4.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0201 Overview.mp4 |
3 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0202 Different Ways to Execute SQL Statements.mp4 |
4.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0203 Some Statements Can Be Cached for Reuse (1).mp4 |
3.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0204 Some Statements Can Be Cached for Reuse (2).mp4 |
7.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0205 Version-Specific Plan Caching Whitepapers.mp4 |
2.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0206 Reducing Plan Cache Pollution.mp4 |
8.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0207 Understanding sp_executesql.mp4 |
5.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0208 Stored Procedures sp_executesql and the Cache.mp4 |
5.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0209 Parameter Sniffing.mp4 |
3.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/02 Why Use Stored Procedures/0210 Summary Why Use Stored Procedures.mp4 |
6.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0301 Overview.mp4 |
3.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0302 What Happens When You Create a Procedure.mp4 |
6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0303 Where Are Stored Procedures Stored (1).mp4 |
8.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0304 Where Are Stored Procedures Stored (2).mp4 |
25.3 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0305 Creating Stored Procedures.mp4 |
41 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0306 Stored Procedure Plans and Caching.mp4 |
81 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0307 Side Effect Plan Cache Flush (1).mp4 |
17.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0308 Side Effect Plan Cache Flush (2).mp4 |
46 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0309 Side Effect Plan Cache Flush (3).mp4 |
3.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0310 Side Effect Plan Cache Flush (4).mp4 |
3.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0311 DEMO Generic Demo Intro.mp4 |
4.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0312 DEMO Setup Credit Sample Database.mp4 |
10.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0313 DEMO Setup Analysis Procedures for Credit.mp4 |
4.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0314 DEMO Object-Level Invalidation or Eviction.mp4 |
2.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0315 DEMO Database-Level Invalidation or Eviction.mp4 |
7.1 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/03 Creation, Compilation, and Invalidation Section 1/0316 DEMO Server-Level Invalidation or Eviction.mp4 |
6.3 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0401 Plan Invalidation.mp4 |
10.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0402 Plan Invalidation Due to Statistics Updates.mp4 |
8.3 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0403 DEMO Plan Invalidation and Statistics - Part 1.mp4 |
74.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0404 Updates to Statistics may not Invalidate Bad Plans.mp4 |
6.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0405 DEMO Plan Invalidation and Statistics - Part 2.mp4 |
69.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0406 Plan Invalidation Recompilation Causes.mp4 |
5.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0407 Stored Procedure Caching + Compilation Concerns.mp4 |
6.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0408 When Should You Recompile.mp4 |
7.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/04 Creation, Compilation, and Invalidation Section 2/0409 Summary Creation and Compilation.mp4 |
6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0501 Overview.mp4 |
8.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0502 Options for Recompilation.mp4 |
10.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0503 sp_recompile object_name.mp4 |
19.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0504 DEMO Long Blocking Chains.mp4 |
84.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0505 CREATE ... WITH RECOMPILE.mp4 |
8.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0506 DEMO CREATE ... WITH RECOMPILE.mp4 |
37.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0507 Conditional Logic.mp4 |
7.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0508 DEMO Conditional Logic - Part 1.mp4 |
55.1 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0509 Modularization.mp4 |
9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/05 Optimization and Recompilation Section 1/0510 DEMO Conditional Logic - Part 2 - Modularization.mp4 |
36.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0601 EXECUTE ... WITH RECOMPILE (1).mp4 |
8.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0602 DEMO EXECUTE ... WITH RECOMPILE For Testing.mp4 |
71.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0603 EXECUTE ... WITH RECOMPILE (2).mp4 |
9.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0604 DEMO Determining Plan Stability.mp4 |
61 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0605 Statement-Level Recompilation.mp4 |
14 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0606 DEMO Recompilation With OPTION (RECOMPILE).mp4 |
33.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0607 DEMO Recompilation With OPTION (Optimize For Literal).mp4 |
31.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0608 DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4 |
59.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/06 Optimization and Recompilation Section 2/0609 DEMO Variables Simulate Optimize For UNKNOWN.mp4 |
17.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0701 OPTION (RECOMPILE).mp4 |
7.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0702 OPTIMIZE FOR ....mp4 |
9.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0703 DEMO Scenario - Setup.mp4 |
26 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0704 DEMO Scenario - Scenario Explained.mp4 |
29.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0705 DEMO Scenario - Conditional Logic Does NOT Work.mp4 |
28.3 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0706 DEMO Scenario - EXEC With RECOMPILE.mp4 |
35.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0707 DEMO Scenario - Conditional Logic Plus Modularization WORKS.mp4 |
31.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0708 DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4 |
24.3 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0709 DEMO Stabilizing Plans With Indexes - Plan Stability.mp4 |
52.7 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0710 DEMO Stabilizing Plans With Indexes - Voila.mp4 |
52.1 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0711 Summary Walkthrough Demo (1).mp4 |
5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/07 Optimization and Recompilation Section 3/0712 Summary Walkthrough Demo (2).mp4 |
6.1 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0801 When Does a Procedure Get Optimized.mp4 |
9.1 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0802 Server-Wide OPTIMIZE FOR UNKNOWN.mp4 |
7.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0803 The Checkered Past of OPTION (RECOMPILE).mp4 |
8.9 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0804 Dynamic String Execution.mp4 |
9.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0805 DEMO Dynamic String Execution.mp4 |
64.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0806 Multi-Purpose Procedures.mp4 |
7.5 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0807 Building Strings Dynamically and Caching.mp4 |
12.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0808 DEMO Multi-Purpose Procedures - Setup and Scenario.mp4 |
39.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0809 DEMO Multi-Purpose Procedures - The Problem.mp4 |
32 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0810 DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4 |
24.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0811 DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4 |
114.8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0812 Patterns and Practices in Statement Recompilation.mp4 |
8.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/08 Optimization and Recompilation Section 4/0813 Summary Stored Procedure Pitfalls-Performance.mp4 |
1.6 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/09 Other Concerns and Considerations/0901 Overview.mp4 |
5.4 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/09 Other Concerns and Considerations/0902 Demystifying Plan Caching for Bad Plans.mp4 |
5.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/09 Other Concerns and Considerations/0903 Secondary Concerns and Considerations.mp4 |
14 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/09 Other Concerns and Considerations/0904 Optimizing Statement and Procedure Performance.mp4 |
5.2 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/09 Other Concerns and Considerations/0905 Just the Tip of the Iceberg.mp4 |
8 MB |
| Pluralsight - SQL Server Optimizing Stored Procedure Performance/09 Other Concerns and Considerations/0906 Course Summary.mp4 |
2.6 MB |
Magnet link
