589689.xyz

SQL Server Optimizing Ad Hoc Statement Performance

  • 收录时间:2018-03-07 16:53:13
  • 文件大小:968MB
  • 下载次数:92
  • 最近下载:2020-12-22 21:42:59
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 05. Plan Cache Pollution/06. Demo Analyzing for Plan Cache Pollution.wmv 59MB
  2. 04. Statement Caching/15. Demo Part 2 - The Right Way to Force Statements.wmv 38MB
  3. 04. Statement Caching/07. Demo Ad Hoc Statements and the Plan Cache.wmv 37MB
  4. 04. Statement Caching/10. Demo query_hash and query_plan_hash.wmv 35MB
  5. 03. Estimates and Selectivity/15. Demo Reading the Histogram.wmv 33MB
  6. 05. Plan Cache Pollution/09. Demo Part 1b - Covering to Make a Query Safe.wmv 31MB
  7. 05. Plan Cache Pollution/08. Demo Part 1a - Optimize for Adhoc Workloads.wmv 29MB
  8. 02. Statement Execution Methods/13. Demo Part 5 - sp_executesql with Unsafe Statement.wmv 29MB
  9. 04. Statement Caching/14. Demo Part 1 - Making a Statement Safe with Covering.wmv 28MB
  10. 03. Estimates and Selectivity/05. Demo Setup and First Look at Statistics.wmv 28MB
  11. 03. Estimates and Selectivity/08. Demo When No Statistics Exist then Heuristics are Used.wmv 27MB
  12. 03. Estimates and Selectivity/06. Demo Updates and Estimates.wmv 27MB
  13. 02. Statement Execution Methods/15. Demo Part 7 - Dynamic String Execution with Unsafe Statement.wmv 23MB
  14. 02. Statement Execution Methods/09. Demo Part 1 - Ad Hoc Safe Statements.wmv 21MB
  15. 05. Plan Cache Pollution/17. Demo Part 3 - Clearing Single-Use Plan Cache Pollution.wmv 21MB
  16. 02. Statement Execution Methods/10. Demo Part 2 - Ad Hoc Unsafe Statements.wmv 20MB
  17. 05. Plan Cache Pollution/15. Demo Part 2c - Optimizing an Expensive Statement.wmv 20MB
  18. 02. Statement Execution Methods/14. Demo Part 6 - Dynamic String Execution with Safe Statement.wmv 18MB
  19. 05. Plan Cache Pollution/14. Demo Part 2b - Forcing a Stable Statement with a Plan Guide.wmv 18MB
  20. 02. Statement Execution Methods/08. Demo Setting Up For Analyzing Cache.wmv 18MB
  21. 03. Estimates and Selectivity/07. Demo Ad Hoc Statements and Variables.wmv 15MB
  22. 05. Plan Cache Pollution/05. Demo Analyzing for Plan Cache Pollution - Setup.wmv 15MB
  23. 05. Plan Cache Pollution/13. Demo Part 2a - Forcing a Stable Statement With sp_executesql.wmv 13MB
  24. 04. Statement Caching/06. Ad Hoc Statement Caching.wmv 13MB
  25. 06. Summary/05. Bringing It All Together.wmv 11MB
  26. 02. Statement Execution Methods/16. Summary Statement Execution Methods.wmv 11MB
  27. 05. Plan Cache Pollution/19. Demo Summary of All Script Executions.wmv 11MB
  28. 04. Statement Caching/12. Changing Ad Hoc Statement Behavior (2).wmv 11MB
  29. 05. Plan Cache Pollution/02. Ad Hoc Plan Cache Pollution Defined.wmv 11MB
  30. 02. Statement Execution Methods/11. Demo Part 3 - Ad Hoc Safe and Unsafe with Variables.wmv 10MB
  31. 02. Statement Execution Methods/12. Demo Part 4 - sp_executesql with Safe Statement.wmv 10MB
  32. 02. Statement Execution Methods/07. Demo Credit Sample Database Setup for This Course.wmv 10MB
  33. 03. Estimates and Selectivity/12. What Do Statistics Tell Us About Our Data (2).wmv 10MB
  34. 03. Estimates and Selectivity/04. Understanding Selectivity.wmv 9MB
  35. 02. Statement Execution Methods/06. Dynamic String Execution and SQL Injection.wmv 8MB
  36. 05. Plan Cache Pollution/07. Balancing Plan Cache Pollution, CPU, and PSP (1).wmv 8MB
  37. 03. Estimates and Selectivity/10. How Do You See Statistics .wmv 8MB
  38. 04. Statement Caching/05. Ad Hoc Statements Safe vs. Unsafe.wmv 7MB
  39. 02. Statement Execution Methods/05. Understanding Dynamic String Execution.wmv 7MB
  40. 02. Statement Execution Methods/03. Understanding Ad Hoc Statements.wmv 7MB
  41. 04. Statement Caching/16. Summary Statement Caching.wmv 7MB
  42. 03. Estimates and Selectivity/02. Statement Execution Simplified.wmv 6MB
  43. 06. Summary/11. Where to Go Next and Final Summary.wmv 6MB
  44. 04. Statement Caching/08. Verifying Plans in Cache NOW.wmv 6MB
  45. 01. Introduction/02. This Course.wmv 6MB
  46. 04. Statement Caching/13. Multiple Plans (Tipping Covering).wmv 6MB
  47. 04. Statement Caching/09. Analyzing the Plan Cache.wmv 6MB
  48. 06. Summary/08. Statement Execution Solutions (3).wmv 6MB
  49. 05. Plan Cache Pollution/16. Balancing Plan Cache Pollution, CPU, and PSP (5).wmv 6MB
  50. 01. Introduction/03. What Does Optimizing Ad Hoc Statement Performance NOT Mean .wmv 5MB
  51. 02. Statement Execution Methods/02. Different Ways to Execute SQL Statements.wmv 5MB
  52. 03. Estimates and Selectivity/16. When and How Does SQL Server Use Statistics .wmv 5MB
  53. 05. Plan Cache Pollution/11. Balancing Plan Cache Pollution, CPU, and PSP (3).wmv 5MB
  54. 06. Summary/02. Statement Execution, Estimates, and Caching (1).wmv 5MB
  55. 03. Estimates and Selectivity/09. Demo Summary Estimates and Selectivity.wmv 5MB
  56. 03. Estimates and Selectivity/03. Cost-Based Optimization.wmv 5MB
  57. 05. Plan Cache Pollution/10. Balancing Plan Cache Pollution, CPU, and PSP (2).wmv 5MB
  58. 06. Summary/07. Statement Execution Solutions (2).wmv 5MB
  59. 01. Introduction/05. Why is This Course Relevant .wmv 5MB
  60. 02. Statement Execution Methods/04. Understanding sp_executesql.wmv 5MB
  61. 01. Introduction/04. What Does Optimizing Ad Hoc Statement Performance Mean .wmv 5MB
  62. 03. Estimates and Selectivity/11. What Do Statistics Tell Us About Our Data (1).wmv 5MB
  63. 03. Estimates and Selectivity/17. Summary Estimates and Selectivity.wmv 4MB
  64. 04. Statement Caching/03. Default Ad Hoc Statement Behavior.wmv 4MB
  65. 01. Introduction/01. Introduction and Background.wmv 4MB
  66. 05. Plan Cache Pollution/20. Summary Plan Cache Pollution.wmv 4MB
  67. 04. Statement Caching/04. Ad Hoc Statement Textual Matching.wmv 4MB
  68. 03. Estimates and Selectivity/14. What Do Statistics Tell Us About Our Data (4).wmv 4MB
  69. 06. Summary/04. Statement Execution Methods, Caching, and Concerns.wmv 4MB
  70. 06. Summary/03. Statement Execution, Estimates, and Caching (2).wmv 4MB
  71. 01. Introduction/07. Course Focus and Structure (2).wmv 3MB
  72. 05. Plan Cache Pollution/18. Alternatives to Ad Hoc Statements.wmv 3MB
  73. 03. Estimates and Selectivity/01. Introduction.wmv 3MB
  74. 04. Statement Caching/11. Changing Ad Hoc Statement Behavior (1).wmv 3MB
  75. 03. Estimates and Selectivity/13. What Do Statistics Tell Us About Our Data (3).wmv 3MB
  76. 01. Introduction/06. Course Focus and Structure (1).wmv 3MB
  77. 06. Summary/09. Summary Statement Execution.wmv 3MB
  78. 05. Plan Cache Pollution/12. Balancing Plan Cache Pollution, CPU, and PSP (4).wmv 3MB
  79. 06. Summary/10. Just the Tip of the Iceberg.wmv 3MB
  80. 04. Statement Caching/01. Introduction.wmv 3MB
  81. 05. Plan Cache Pollution/01. Plan Cache Pollution.wmv 3MB
  82. 04. Statement Caching/02. What Affects Ad Hoc Statement Behavior .wmv 3MB
  83. 06. Summary/06. Statement Execution Solutions (1).wmv 3MB
  84. 05. Plan Cache Pollution/03. Plan Cache Stores.wmv 3MB
  85. 06. Summary/01. Statement Execution Summary.wmv 2MB
  86. 05. Plan Cache Pollution/04. Verifying State of Plan Cache.wmv 2MB
  87. 02. Statement Execution Methods/01. Introduction.wmv 1MB
  88. sqlserver-optimizing-adhoc-statement-performance.zip 971KB