SQL Server Optimizing Ad Hoc Statement Performance | 65AD189E72E17D11C79C82BF71A3D90853C535EC

SQL Server Optimizing Ad Hoc Statement Performance

Name	SQL Server Optimizing Ad Hoc Statement Performance	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.0 GB
Total Files	88
Hash	65AD189E72E17D11C79C82BF71A3D90853C535EC

/05. Plan Cache Pollution/
06. Demo Analyzing for Plan Cache Pollution.wmv	61.5 MB
09. Demo Part 1b - Covering to Make a Query Safe.wmv	32.8 MB
08. Demo Part 1a - Optimize for Adhoc Workloads.wmv	30.2 MB
17. Demo Part 3 - Clearing Single-Use Plan Cache Pollution.wmv	22.4 MB
15. Demo Part 2c - Optimizing an Expensive Statement.wmv	20.7 MB
14. Demo Part 2b - Forcing a Stable Statement with a Plan Guide.wmv	18.9 MB
05. Demo Analyzing for Plan Cache Pollution - Setup.wmv	15.3 MB
13. Demo Part 2a - Forcing a Stable Statement With sp_executesql.wmv	13.6 MB
19. Demo Summary of All Script Executions.wmv	11.2 MB
02. Ad Hoc Plan Cache Pollution Defined.wmv	11.1 MB
07. Balancing Plan Cache Pollution, CPU, and PSP (1).wmv	8.6 MB
16. Balancing Plan Cache Pollution, CPU, and PSP (5).wmv	5.8 MB
11. Balancing Plan Cache Pollution, CPU, and PSP (3).wmv	5.6 MB
10. Balancing Plan Cache Pollution, CPU, and PSP (2).wmv	5.2 MB
20. Summary Plan Cache Pollution.wmv	4.5 MB
18. Alternatives to Ad Hoc Statements.wmv	3.6 MB
12. Balancing Plan Cache Pollution, CPU, and PSP (4).wmv	3.1 MB
01. Plan Cache Pollution.wmv	2.9 MB
03. Plan Cache Stores.wmv	2.7 MB
04. Verifying State of Plan Cache.wmv	2.1 MB
/04. Statement Caching/
15. Demo Part 2 - The Right Way to Force Statements.wmv	39.5 MB
07. Demo Ad Hoc Statements and the Plan Cache.wmv	39.1 MB
10. Demo query_hash and query_plan_hash.wmv	37.0 MB
14. Demo Part 1 - Making a Statement Safe with Covering.wmv	29.9 MB
06. Ad Hoc Statement Caching.wmv	13.2 MB
12. Changing Ad Hoc Statement Behavior (2).wmv	11.1 MB
05. Ad Hoc Statements Safe vs. Unsafe.wmv	7.8 MB
16. Summary Statement Caching.wmv	7.4 MB
08. Verifying Plans in Cache NOW.wmv	6.4 MB
13. Multiple Plans (Tipping Covering).wmv	6.2 MB
09. Analyzing the Plan Cache.wmv	6.2 MB
03. Default Ad Hoc Statement Behavior.wmv	4.7 MB
04. Ad Hoc Statement Textual Matching.wmv	4.3 MB
11. Changing Ad Hoc Statement Behavior (1).wmv	3.5 MB
01. Introduction.wmv	3.0 MB
02. What Affects Ad Hoc Statement Behavior .wmv	2.9 MB
/03. Estimates and Selectivity/
15. Demo Reading the Histogram.wmv	34.2 MB
05. Demo Setup and First Look at Statistics.wmv	29.1 MB
08. Demo When No Statistics Exist then Heuristics are Used.wmv	28.5 MB
06. Demo Updates and Estimates.wmv	28.4 MB
07. Demo Ad Hoc Statements and Variables.wmv	16.1 MB
12. What Do Statistics Tell Us About Our Data (2).wmv	10.3 MB
04. Understanding Selectivity.wmv	9.3 MB
10. How Do You See Statistics .wmv	8.6 MB
02. Statement Execution Simplified.wmv	6.8 MB
16. When and How Does SQL Server Use Statistics .wmv	5.6 MB
09. Demo Summary Estimates and Selectivity.wmv	5.4 MB
03. Cost-Based Optimization.wmv	5.3 MB
11. What Do Statistics Tell Us About Our Data (1).wmv	4.9 MB
17. Summary Estimates and Selectivity.wmv	4.7 MB
14. What Do Statistics Tell Us About Our Data (4).wmv	4.2 MB
01. Introduction.wmv	3.6 MB
13. What Do Statistics Tell Us About Our Data (3).wmv	3.5 MB
/02. Statement Execution Methods/
13. Demo Part 5 - sp_executesql with Unsafe Statement.wmv	30.1 MB
15. Demo Part 7 - Dynamic String Execution with Unsafe Statement.wmv	23.9 MB
09. Demo Part 1 - Ad Hoc Safe Statements.wmv	22.5 MB
10. Demo Part 2 - Ad Hoc Unsafe Statements.wmv	20.8 MB
14. Demo Part 6 - Dynamic String Execution with Safe Statement.wmv	19.0 MB
08. Demo Setting Up For Analyzing Cache.wmv	18.5 MB
16. Summary Statement Execution Methods.wmv	11.4 MB
11. Demo Part 3 - Ad Hoc Safe and Unsafe with Variables.wmv	10.7 MB
12. Demo Part 4 - sp_executesql with Safe Statement.wmv	10.6 MB
07. Demo Credit Sample Database Setup for This Course.wmv	10.4 MB
06. Dynamic String Execution and SQL Injection.wmv	8.7 MB
05. Understanding Dynamic String Execution.wmv	7.5 MB
03. Understanding Ad Hoc Statements.wmv	7.4 MB
02. Different Ways to Execute SQL Statements.wmv	5.6 MB
04. Understanding sp_executesql.wmv	5.0 MB
01. Introduction.wmv	1.5 MB
/06. Summary/
05. Bringing It All Together.wmv	11.4 MB
11. Where to Go Next and Final Summary.wmv	6.5 MB
08. Statement Execution Solutions (3).wmv	5.9 MB
02. Statement Execution, Estimates, and Caching (1).wmv	5.5 MB
07. Statement Execution Solutions (2).wmv	5.2 MB
04. Statement Execution Methods, Caching, and Concerns.wmv	4.2 MB
03. Statement Execution, Estimates, and Caching (2).wmv	4.0 MB
09. Summary Statement Execution.wmv	3.3 MB
10. Just the Tip of the Iceberg.wmv	3.1 MB
06. Statement Execution Solutions (1).wmv	2.8 MB
01. Statement Execution Summary.wmv	2.2 MB
/01. Introduction/
02. This Course.wmv	6.3 MB
03. What Does Optimizing Ad Hoc Statement Performance NOT Mean .wmv	5.7 MB
05. Why is This Course Relevant .wmv	5.1 MB
04. What Does Optimizing Ad Hoc Statement Performance Mean .wmv	4.9 MB
01. Introduction and Background.wmv	4.6 MB
07. Course Focus and Structure (2).wmv	3.6 MB
06. Course Focus and Structure (1).wmv	3.4 MB
/
sqlserver-optimizing-adhoc-statement-performance.zip	994.6 KB
Total files 88