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