Pluralsight SQL Server Optimizing Stored Procedure Performance | B211D45DA880A954CB697E73278FEABC5333FC9B

Pluralsight SQL Server Optimizing Stored Procedure Performance

Name	Pluralsight - SQL Server Optimizing Stored Procedure Performance	DOWNLOAD Copy Link
Total Size	1.9 GB
Total Files	93
Hash	B211D45DA880A954CB697E73278FEABC5333FC9B

/01 Introduction/
0101 Introduction.mp4	5.3 MB
0102 This Course.mp4	4.9 MB
0103 What Does Optimizing Stored Procedure Performance Mean.mp4	6.0 MB
0104 Does This Sound Familiar.mp4	4.4 MB
0105 What Does Optimizing Stored Procedure Performance NOT Mean.mp4	7.3 MB
0106 Why This Course Is Relevant.mp4	5.8 MB
0107 Course Focus and Structure (1).mp4	4.2 MB
0108 Course Focus and Structure (2).mp4	4.7 MB
/02 Why Use Stored Procedures/
0201 Overview.mp4	3.2 MB
0202 Different Ways to Execute SQL Statements.mp4	5.0 MB
0203 Some Statements Can Be Cached for Reuse (1).mp4	3.9 MB
0204 Some Statements Can Be Cached for Reuse (2).mp4	8.1 MB
0205 Version-Specific Plan Caching Whitepapers.mp4	2.3 MB
0206 Reducing Plan Cache Pollution.mp4	9.3 MB
0207 Understanding sp_executesql.mp4	5.7 MB
0208 Stored Procedures sp_executesql and the Cache.mp4	5.5 MB
0209 Parameter Sniffing.mp4	4.0 MB
0210 Summary Why Use Stored Procedures.mp4	6.9 MB
/03 Creation, Compilation, and Invalidation Section 1/
0301 Overview.mp4	3.6 MB
0302 What Happens When You Create a Procedure.mp4	6.3 MB
0303 Where Are Stored Procedures Stored (1).mp4	9.1 MB
0304 Where Are Stored Procedures Stored (2).mp4	26.6 MB
0305 Creating Stored Procedures.mp4	43.0 MB
0306 Stored Procedure Plans and Caching.mp4	84.9 MB
0307 Side Effect Plan Cache Flush (1).mp4	18.1 MB
0308 Side Effect Plan Cache Flush (2).mp4	48.2 MB
0309 Side Effect Plan Cache Flush (3).mp4	3.8 MB
0310 Side Effect Plan Cache Flush (4).mp4	4.1 MB
0311 DEMO Generic Demo Intro.mp4	5.1 MB
0312 DEMO Setup Credit Sample Database.mp4	11.4 MB
0313 DEMO Setup Analysis Procedures for Credit.mp4	5.0 MB
0314 DEMO Object-Level Invalidation or Eviction.mp4	2.7 MB
0315 DEMO Database-Level Invalidation or Eviction.mp4	7.5 MB
0316 DEMO Server-Level Invalidation or Eviction.mp4	6.7 MB
/04 Creation, Compilation, and Invalidation Section 2/
0401 Plan Invalidation.mp4	11.4 MB
0402 Plan Invalidation Due to Statistics Updates.mp4	8.7 MB
0403 DEMO Plan Invalidation and Statistics - Part 1.mp4	78.4 MB
0404 Updates to Statistics may not Invalidate Bad Plans.mp4	7.0 MB
0405 DEMO Plan Invalidation and Statistics - Part 2.mp4	73.3 MB
0406 Plan Invalidation Recompilation Causes.mp4	6.2 MB
0407 Stored Procedure Caching + Compilation Concerns.mp4	7.3 MB
0408 When Should You Recompile.mp4	7.8 MB
0409 Summary Creation and Compilation.mp4	6.3 MB
/05 Optimization and Recompilation Section 1/
0501 Overview.mp4	9.0 MB
0502 Options for Recompilation.mp4	10.9 MB
0503 sp_recompile object_name.mp4	20.1 MB
0504 DEMO Long Blocking Chains.mp4	88.8 MB
0505 CREATE ... WITH RECOMPILE.mp4	8.8 MB
0506 DEMO CREATE ... WITH RECOMPILE.mp4	39.5 MB
0507 Conditional Logic.mp4	7.7 MB
0508 DEMO Conditional Logic - Part 1.mp4	57.8 MB
0509 Modularization.mp4	9.4 MB
0510 DEMO Conditional Logic - Part 2 - Modularization.mp4	38.3 MB
/06 Optimization and Recompilation Section 2/
0601 EXECUTE ... WITH RECOMPILE (1).mp4	8.6 MB
0602 DEMO EXECUTE ... WITH RECOMPILE For Testing.mp4	75.2 MB
0603 EXECUTE ... WITH RECOMPILE (2).mp4	9.6 MB
0604 DEMO Determining Plan Stability.mp4	63.9 MB
0605 Statement-Level Recompilation.mp4	14.7 MB
0606 DEMO Recompilation With OPTION (RECOMPILE).mp4	35.2 MB
0607 DEMO Recompilation With OPTION (Optimize For Literal).mp4	33.0 MB
0608 DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4	62.4 MB
0609 DEMO Variables Simulate Optimize For UNKNOWN.mp4	18.4 MB
/07 Optimization and Recompilation Section 3/
0701 OPTION (RECOMPILE).mp4	8.1 MB
0702 OPTIMIZE FOR ....mp4	10.1 MB
0703 DEMO Scenario - Setup.mp4	27.2 MB
0704 DEMO Scenario - Scenario Explained.mp4	31.3 MB
0705 DEMO Scenario - Conditional Logic Does NOT Work.mp4	29.7 MB
0706 DEMO Scenario - EXEC With RECOMPILE.mp4	36.9 MB
0707 DEMO Scenario - Conditional Logic Plus Modularization WORKS.mp4	33.4 MB
0708 DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4	25.4 MB
0709 DEMO Stabilizing Plans With Indexes - Plan Stability.mp4	55.3 MB
0710 DEMO Stabilizing Plans With Indexes - Voila.mp4	54.6 MB
0711 Summary Walkthrough Demo (1).mp4	5.2 MB
0712 Summary Walkthrough Demo (2).mp4	6.4 MB
/08 Optimization and Recompilation Section 4/
0801 When Does a Procedure Get Optimized.mp4	9.5 MB
0802 Server-Wide OPTIMIZE FOR UNKNOWN.mp4	7.6 MB
0803 The Checkered Past of OPTION (RECOMPILE).mp4	9.3 MB
0804 Dynamic String Execution.mp4	9.8 MB
0805 DEMO Dynamic String Execution.mp4	67.6 MB
0806 Multi-Purpose Procedures.mp4	7.9 MB
0807 Building Strings Dynamically and Caching.mp4	12.8 MB
0808 DEMO Multi-Purpose Procedures - Setup and Scenario.mp4	41.5 MB
0809 DEMO Multi-Purpose Procedures - The Problem.mp4	33.6 MB
0810 DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4	26.0 MB
0811 DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4	120.4 MB
0812 Patterns and Practices in Statement Recompilation.mp4	8.8 MB
0813 Summary Stored Procedure Pitfalls-Performance.mp4	1.6 MB
/09 Other Concerns and Considerations/
0901 Overview.mp4	5.6 MB
0902 Demystifying Plan Caching for Bad Plans.mp4	5.5 MB
0903 Secondary Concerns and Considerations.mp4	14.7 MB
0904 Optimizing Statement and Procedure Performance.mp4	5.4 MB
0905 Just the Tip of the Iceberg.mp4	8.4 MB
0906 Course Summary.mp4	2.7 MB
Total files 93