Pluralsight - SQL Server Optimizing Stored Procedure Performance

1.78 GB | 00:16:47 | mp4 | 1024X768 | 4:3
Genre:eLearning |Language:English

Files Included :
0101 Introduction.mp4 (5.04 MB)
0102 This Course.mp4 (4.63 MB)
0103 What Does Optimizing Stored Procedure Performance Mean.mp4 (5.74 MB)
0104 Does This Sound Familiar.mp4 (4.16 MB)
0105 What Does Optimizing Stored Procedure Performance NOT Mean.mp4 (6.94 MB)
0106 Why This Course Is Relevant.mp4 (5.53 MB)
0107 Course Focus and Structure (1).mp4 (4.03 MB)
0108 Course Focus and Structure (2).mp4 (4.51 MB)
0201 Overview.mp4 (3.01 MB)
0202 Different Ways to Execute SQL Statements.mp4 (4.74 MB)
0203 Some Statements Can Be Cached for Reuse (1).mp4 (3.73 MB)
0204 Some Statements Can Be Cached for Reuse (2).mp4 (7.75 MB)
0205 Version-Specific Plan Caching Whitepapers.mp4 (2.19 MB)
0206 Reducing Plan Cache Pollution.mp4 (8.82 MB)
0207 Understanding sp executesql.mp4 (5.4 MB)
0208 Stored Procedures sp executesql and the Cache.mp4 (5.22 MB)
0209 Parameter Sniffing.mp4 (3.79 MB)
0210 Summary Why Use Stored Procedures.mp4 (6.57 MB)
0301 Overview.mp4 (3.43 MB)
0302 What Happens When You Create a Procedure.mp4 (6.05 MB)
0303 Where Are Stored Procedures Stored (1).mp4 (8.65 MB)
0304 Where Are Stored Procedures Stored (2).mp4 (25.32 MB)
0305 Creating Stored Procedures.mp4 (40.96 MB)
0306 Stored Procedure Plans and Caching.mp4 (80.96 MB)
0307 Side Effect Plan Cache Flush (1).mp4 (17.23 MB)
0308 Side Effect Plan Cache Flush (2).mp4 (46 MB)
0309 Side Effect Plan Cache Flush (3).mp4 (3.66 MB)
0310 Side Effect Plan Cache Flush (4).mp4 (3.95 MB)
0311 DEMO Generic Demo Intro.mp4 (4.86 MB)
0313 DEMO Setup Analysis Procedures for Credit.mp4 (4.8 MB)
0314 DEMO Object-Level Invalidation or Eviction.mp4 (2.59 MB)
0315 DEMO Database-Level Invalidation or Eviction.mp4 (7.11 MB)
0316 DEMO Server-Level Invalidation or Eviction.mp4 (6.35 MB)
0401 Plan Invalidation.mp4 (10.86 MB)
0402 Plan Invalidation Due to Statistics Updates.mp4 (8.28 MB)
0403 DEMO Plan Invalidation and Statistics - Part 1.mp4 (74.76 MB)
0404 Updates to Statistics may not Invalidate Bad Plans.mp4 (6.63 MB)
0405 DEMO Plan Invalidation and Statistics - Part 2.mp4 (69.88 MB)
0406 Plan Invalidation Recompilation Causes.mp4 (5.89 MB)
0407 Stored Procedure Caching + Compilation Concerns.mp4 (6.94 MB)
0408 When Should You Recompile.mp4 (7.47 MB)
0409 Summary Creation and Compilation.mp4 (5.96 MB)
0501 Overview.mp4 (8.59 MB)
0502 Options for Recompilation.mp4 (10.36 MB)
0503 sp recompile object name.mp4 (19.17 MB)
0504 DEMO Long Blocking Chains.mp4 (84.67 MB)
0505 CREATE WITH RECOMPILE.mp4 (8.36 MB)
0506 DEMO CREATE WITH RECOMPILE.mp4 (37.62 MB)
0507 Conditional Logic.mp4 (7.36 MB)
0508 DEMO Conditional Logic - Part 1.mp4 (55.11 MB)
0509 Modularization.mp4 (8.99 MB)
0510 DEMO Conditional Logic - Part 2 - Modularization.mp4 (36.53 MB)
0601 EXECUTE WITH RECOMPILE (1).mp4 (8.19 MB)
0602 DEMO EXECUTE WITH RECOMPILE For Testing.mp4 (71.72 MB)
0603 EXECUTE WITH RECOMPILE (2).mp4 (9.2 MB)
0604 DEMO Determining Plan Stability.mp4 (60.97 MB)
0605 Statement-Level Recompilation.mp4 (13.99 MB)
0606 DEMO Recompilation With OPTION (RECOMPILE).mp4 (33.53 MB)
0607 DEMO Recompilation With OPTION (Optimize For Literal).mp4 (31.47 MB)
0608 DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4 (59.49 MB)
0609 DEMO Variables Simulate Optimize For UNKNOWN.mp4 (17.59 MB)
0701 OPTION (RECOMPILE).mp4 (7.77 MB)
0702 OPTIMIZE FOR.mp4 (9.67 MB)
0703 DEMO Scenario - Setup.mp4 (25.98 MB)
0704 DEMO Scenario - Scenario Explained.mp4 (29.8 MB)
0705 DEMO Scenario - Conditional Logic Does NOT Work.mp4 (28.35 MB)
0706 DEMO Scenario - EXEC With RECOMPILE.mp4 (35.2 MB)
0707 DEMO Scenario - Conditional Logic Plus Modularization WORKS.mp4 (31.87 MB)
0708 DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4 (24.26 MB)
0709 DEMO Stabilizing Plans With Indexes - Plan Stability.mp4 (52.74 MB)
0710 DEMO Stabilizing Plans With Indexes - Voila.mp4 (52.05 MB)
0711 Summary Walkthrough Demo (1).mp4 (4.97 MB)
0712 Summary Walkthrough Demo (2).mp4 (6.09 MB)
0801 When Does a Procedure Get Optimized.mp4 (9.06 MB)
0802 Server-Wide OPTIMIZE FOR UNKNOWN.mp4 (7.22 MB)
0803 The Checkered Past of OPTION (RECOMPILE).mp4 (8.87 MB)
0804 Dynamic String Execution.mp4 (9.37 MB)
0805 DEMO Dynamic String Execution.mp4 (64.43 MB)
0806 Multi-Purpose Procedures.mp4 (7.54 MB)
0807 Building Strings Dynamically and Caching.mp4 (12.24 MB)
0808 DEMO Multi-Purpose Procedures - Setup and Scenario.mp4 (39.62 MB)
0809 DEMO Multi-Purpose Procedures - The Problem.mp4 (32.03 MB)
0810 DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4 (24.79 MB)
0811 DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4 (114.85 MB)
0812 Patterns and Practices in Statement Recompilation.mp4 (8.38 MB)
0813 Summary Stored Procedure Pitfalls-Performance.mp4 (1.56 MB)
0901 Overview.mp4 (5.36 MB)
0902 Demystifying Plan Caching for Bad Plans.mp4 (5.2 MB)
0903 Secondary Concerns and Considerations.mp4 (13.98 MB)
0904 Optimizing Statement and Procedure Performance.mp4 (5.18 MB)
0905 Just the Tip of the Iceberg.mp4 (8 MB)
0906 Course Summary.mp4 (2.61 MB)]
Screenshot