SQL Server Optimizing Stored Procedure Performance [2014, ENG]

seeders: 6 leechers: 0
Added 11 years ago by Alex Mill in Other
Downloaded 0 time.
RuTracker.org
SQL Server Optimizing Stored Procedure Performance [2014, ENG]

Torrent Contents Size: 1.79 GB

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

Description

Related Torrents

Location

Trackers

Tracker name
http://bt.t-ru.org/ann?magnet
http://bt1.t-ru.org/ann
http://bt2.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337
Torrent hash: