SQL Server Optimizing Ad Hoc Statement Performance
File List
- 05. Plan Cache Pollution/06. Demo Analyzing for Plan Cache Pollution.wmv 58.6 MB
- 04. Statement Caching/15. Demo Part 2 - The Right Way to Force Statements.wmv 37.7 MB
- 04. Statement Caching/07. Demo Ad Hoc Statements and the Plan Cache.wmv 37.3 MB
- 04. Statement Caching/10. Demo query_hash and query_plan_hash.wmv 35.3 MB
- 03. Estimates and Selectivity/15. Demo Reading the Histogram.wmv 32.6 MB
- 05. Plan Cache Pollution/09. Demo Part 1b - Covering to Make a Query Safe.wmv 31.2 MB
- 05. Plan Cache Pollution/08. Demo Part 1a - Optimize for Adhoc Workloads.wmv 28.8 MB
- 02. Statement Execution Methods/13. Demo Part 5 - sp_executesql with Unsafe Statement.wmv 28.7 MB
- 04. Statement Caching/14. Demo Part 1 - Making a Statement Safe with Covering.wmv 28.5 MB
- 03. Estimates and Selectivity/05. Demo Setup and First Look at Statistics.wmv 27.7 MB
- 03. Estimates and Selectivity/08. Demo When No Statistics Exist then Heuristics are Used.wmv 27.2 MB
- 03. Estimates and Selectivity/06. Demo Updates and Estimates.wmv 27.1 MB
- 02. Statement Execution Methods/15. Demo Part 7 - Dynamic String Execution with Unsafe Statement.wmv 22.8 MB
- 02. Statement Execution Methods/09. Demo Part 1 - Ad Hoc Safe Statements.wmv 21.4 MB
- 05. Plan Cache Pollution/17. Demo Part 3 - Clearing Single-Use Plan Cache Pollution.wmv 21.4 MB
- 02. Statement Execution Methods/10. Demo Part 2 - Ad Hoc Unsafe Statements.wmv 19.8 MB
- 05. Plan Cache Pollution/15. Demo Part 2c - Optimizing an Expensive Statement.wmv 19.7 MB
- 02. Statement Execution Methods/14. Demo Part 6 - Dynamic String Execution with Safe Statement.wmv 18.1 MB
- 05. Plan Cache Pollution/14. Demo Part 2b - Forcing a Stable Statement with a Plan Guide.wmv 18.0 MB
- 02. Statement Execution Methods/08. Demo Setting Up For Analyzing Cache.wmv 17.7 MB
- 03. Estimates and Selectivity/07. Demo Ad Hoc Statements and Variables.wmv 15.4 MB
- 05. Plan Cache Pollution/05. Demo Analyzing for Plan Cache Pollution - Setup.wmv 14.6 MB
- 05. Plan Cache Pollution/13. Demo Part 2a - Forcing a Stable Statement With sp_executesql.wmv 13.0 MB
- 04. Statement Caching/06. Ad Hoc Statement Caching.wmv 12.6 MB
- 06. Summary/05. Bringing It All Together.wmv 10.9 MB
- 02. Statement Execution Methods/16. Summary Statement Execution Methods.wmv 10.8 MB
- 05. Plan Cache Pollution/19. Demo Summary of All Script Executions.wmv 10.7 MB
- 04. Statement Caching/12. Changing Ad Hoc Statement Behavior (2).wmv 10.6 MB
- 05. Plan Cache Pollution/02. Ad Hoc Plan Cache Pollution Defined.wmv 10.6 MB
- 02. Statement Execution Methods/11. Demo Part 3 - Ad Hoc Safe and Unsafe with Variables.wmv 10.2 MB
- 02. Statement Execution Methods/12. Demo Part 4 - sp_executesql with Safe Statement.wmv 10.1 MB
- 02. Statement Execution Methods/07. Demo Credit Sample Database Setup for This Course.wmv 9.9 MB
- 03. Estimates and Selectivity/12. What Do Statistics Tell Us About Our Data (2).wmv 9.8 MB
- 03. Estimates and Selectivity/04. Understanding Selectivity.wmv 8.9 MB
- 02. Statement Execution Methods/06. Dynamic String Execution and SQL Injection.wmv 8.3 MB
- 05. Plan Cache Pollution/07. Balancing Plan Cache Pollution, CPU, and PSP (1).wmv 8.2 MB
- 03. Estimates and Selectivity/10. How Do You See Statistics .wmv 8.2 MB
- 04. Statement Caching/05. Ad Hoc Statements Safe vs. Unsafe.wmv 7.4 MB
- 02. Statement Execution Methods/05. Understanding Dynamic String Execution.wmv 7.1 MB
- 02. Statement Execution Methods/03. Understanding Ad Hoc Statements.wmv 7.0 MB
- 04. Statement Caching/16. Summary Statement Caching.wmv 7.0 MB
- 03. Estimates and Selectivity/02. Statement Execution Simplified.wmv 6.5 MB
- 06. Summary/11. Where to Go Next and Final Summary.wmv 6.2 MB
- 04. Statement Caching/08. Verifying Plans in Cache NOW.wmv 6.1 MB
- 01. Introduction/02. This Course.wmv 6.0 MB
- 04. Statement Caching/13. Multiple Plans (Tipping Covering).wmv 5.9 MB
- 04. Statement Caching/09. Analyzing the Plan Cache.wmv 5.9 MB
- 06. Summary/08. Statement Execution Solutions (3).wmv 5.6 MB
- 05. Plan Cache Pollution/16. Balancing Plan Cache Pollution, CPU, and PSP (5).wmv 5.5 MB
- 01. Introduction/03. What Does Optimizing Ad Hoc Statement Performance NOT Mean .wmv 5.4 MB
- 02. Statement Execution Methods/02. Different Ways to Execute SQL Statements.wmv 5.4 MB
- 03. Estimates and Selectivity/16. When and How Does SQL Server Use Statistics .wmv 5.4 MB
- 05. Plan Cache Pollution/11. Balancing Plan Cache Pollution, CPU, and PSP (3).wmv 5.3 MB
- 06. Summary/02. Statement Execution, Estimates, and Caching (1).wmv 5.2 MB
- 03. Estimates and Selectivity/09. Demo Summary Estimates and Selectivity.wmv 5.1 MB
- 03. Estimates and Selectivity/03. Cost-Based Optimization.wmv 5.0 MB
- 05. Plan Cache Pollution/10. Balancing Plan Cache Pollution, CPU, and PSP (2).wmv 4.9 MB
- 06. Summary/07. Statement Execution Solutions (2).wmv 4.9 MB
- 01. Introduction/05. Why is This Course Relevant .wmv 4.9 MB
- 02. Statement Execution Methods/04. Understanding sp_executesql.wmv 4.8 MB
- 01. Introduction/04. What Does Optimizing Ad Hoc Statement Performance Mean .wmv 4.7 MB
- 03. Estimates and Selectivity/11. What Do Statistics Tell Us About Our Data (1).wmv 4.7 MB
- 03. Estimates and Selectivity/17. Summary Estimates and Selectivity.wmv 4.5 MB
- 04. Statement Caching/03. Default Ad Hoc Statement Behavior.wmv 4.4 MB
- 01. Introduction/01. Introduction and Background.wmv 4.3 MB
- 05. Plan Cache Pollution/20. Summary Plan Cache Pollution.wmv 4.3 MB
- 04. Statement Caching/04. Ad Hoc Statement Textual Matching.wmv 4.1 MB
- 03. Estimates and Selectivity/14. What Do Statistics Tell Us About Our Data (4).wmv 4.0 MB
- 06. Summary/04. Statement Execution Methods, Caching, and Concerns.wmv 4.0 MB
- 06. Summary/03. Statement Execution, Estimates, and Caching (2).wmv 3.9 MB
- 01. Introduction/07. Course Focus and Structure (2).wmv 3.4 MB
- 05. Plan Cache Pollution/18. Alternatives to Ad Hoc Statements.wmv 3.4 MB
- 03. Estimates and Selectivity/01. Introduction.wmv 3.4 MB
- 04. Statement Caching/11. Changing Ad Hoc Statement Behavior (1).wmv 3.3 MB
- 03. Estimates and Selectivity/13. What Do Statistics Tell Us About Our Data (3).wmv 3.3 MB
- 01. Introduction/06. Course Focus and Structure (1).wmv 3.2 MB
- 06. Summary/09. Summary Statement Execution.wmv 3.2 MB
- 05. Plan Cache Pollution/12. Balancing Plan Cache Pollution, CPU, and PSP (4).wmv 3.0 MB
- 06. Summary/10. Just the Tip of the Iceberg.wmv 2.9 MB
- 04. Statement Caching/01. Introduction.wmv 2.9 MB
- 05. Plan Cache Pollution/01. Plan Cache Pollution.wmv 2.8 MB
- 04. Statement Caching/02. What Affects Ad Hoc Statement Behavior .wmv 2.8 MB
- 06. Summary/06. Statement Execution Solutions (1).wmv 2.7 MB
- 05. Plan Cache Pollution/03. Plan Cache Stores.wmv 2.5 MB
- 06. Summary/01. Statement Execution Summary.wmv 2.1 MB
- 05. Plan Cache Pollution/04. Verifying State of Plan Cache.wmv 2.0 MB
- 02. Statement Execution Methods/01. Introduction.wmv 1.4 MB
- sqlserver-optimizing-adhoc-statement-performance.zip 971.3 KB
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.