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