589689.xyz

Sql Serrver - Troubleshooting Query Plan Quality Issues

  • 收录时间:2018-02-24 23:08:40
  • 文件大小:396MB
  • 下载次数:120
  • 最近下载:2021-01-17 19:55:07
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 04.Query Plan Quality Patterns and Resolutions/19.Demo - Hidden Column Correlation.wmv 34MB
  2. 02.Why Query Plan Quality Matters/08.Demo - Operator Cost.wmv 31MB
  3. 04.Query Plan Quality Patterns and Resolutions/10.Demo - Manual Statistics Updates.wmv 28MB
  4. 04.Query Plan Quality Patterns and Resolutions/07.Demo - Resolving NO_RECOMPUTE Issues.wmv 19MB
  5. 04.Query Plan Quality Patterns and Resolutions/11.Demo - Using Trace Flag 2371.wmv 17MB
  6. 04.Query Plan Quality Patterns and Resolutions/15.Demo - Using FULLSCAN Manual Statistics Updates.wmv 16MB
  7. 04.Query Plan Quality Patterns and Resolutions/27.Demo - Parameter Sniffing.wmv 15MB
  8. 02.Why Query Plan Quality Matters/12.Demo - Under-estimates and Spills.wmv 15MB
  9. 02.Why Query Plan Quality Matters/14.Demo - Over-estimates and Concurrency.wmv 14MB
  10. 03.Identifying Query Plan Quality Issues/11.Demo - Row Count Statistics in sys.dm_exec_query_stats.wmv 14MB
  11. 04.Query Plan Quality Patterns and Resolutions/34.Demo - Hints.wmv 13MB
  12. 04.Query Plan Quality Patterns and Resolutions/17.Demo - Filtered Statistics Threshold Update Problem.wmv 12MB
  13. 04.Query Plan Quality Patterns and Resolutions/16.Demo - Creating Filtered Statistics.wmv 11MB
  14. 03.Identifying Query Plan Quality Issues/05.Demo - Capturing an Actual Plan.wmv 10MB
  15. 04.Query Plan Quality Patterns and Resolutions/30.Demo - Complex Predicates.wmv 10MB
  16. 04.Query Plan Quality Patterns and Resolutions/32.Demo - Query Complexity.wmv 9MB
  17. 04.Query Plan Quality Patterns and Resolutions/23.Demo - Table Variable Usage.wmv 8MB
  18. 03.Identifying Query Plan Quality Issues/09.Demo - Inaccurate Cardinality Estimate Event Capture.wmv 8MB
  19. 04.Query Plan Quality Patterns and Resolutions/14.Demo - Using sys.dm_db_stats_properties.wmv 7MB
  20. 04.Query Plan Quality Patterns and Resolutions/25.Demo - MSTV UDFs.wmv 7MB
  21. 03.Identifying Query Plan Quality Issues/10.Demo - ConvertIssue Plan Attributes.wmv 6MB
  22. 04.Query Plan Quality Patterns and Resolutions/21.Demo - Comparison of Intra-Table Columns.wmv 6MB
  23. 04.Query Plan Quality Patterns and Resolutions/13.Demo - Using DBCC SHOW_STATISTICS.wmv 6MB
  24. 04.Query Plan Quality Patterns and Resolutions/09.Demo - Checking STATS_DATE.wmv 4MB
  25. 02.Why Query Plan Quality Matters/02.Which is the 'Good' Plan.wmv 4MB
  26. 03.Identifying Query Plan Quality Issues/07.Demo - SQL Sentry Plan Explorer.wmv 4MB
  27. 04.Query Plan Quality Patterns and Resolutions/06.Demo - Checking sys.stats and sp_helpstats.wmv 4MB
  28. 02.Why Query Plan Quality Matters/15.Impacted Query Optimizer Decisions.wmv 3MB
  29. 04.Query Plan Quality Patterns and Resolutions/31.Query Complexity.wmv 3MB
  30. 02.Why Query Plan Quality Matters/03.Cardinality Estimates.wmv 3MB
  31. 04.Query Plan Quality Patterns and Resolutions/04.Missing or Stale Statistics (1).wmv 2MB
  32. 04.Query Plan Quality Patterns and Resolutions/12.Sampling Issues.wmv 2MB
  33. 02.Why Query Plan Quality Matters/10.Memory Operators.wmv 2MB
  34. 03.Identifying Query Plan Quality Issues/08.SQL Server 2012 Supplemental Information.wmv 2MB
  35. 04.Query Plan Quality Patterns and Resolutions/26.Parameter Sniffing.wmv 2MB
  36. 04.Query Plan Quality Patterns and Resolutions/08.Missing or Stale Statistics (2).wmv 2MB
  37. 02.Why Query Plan Quality Matters/07.Operator Cost (3).wmv 2MB
  38. 02.Why Query Plan Quality Matters/13.Over-estimates and Concurrency.wmv 2MB
  39. 04.Query Plan Quality Patterns and Resolutions/02.Before Jumping In....wmv 2MB
  40. 04.Query Plan Quality Patterns and Resolutions/24.Scalar and MSTV UDFs.wmv 2MB
  41. 03.Identifying Query Plan Quality Issues/04.Capturing an Actual Plan.wmv 2MB
  42. 04.Query Plan Quality Patterns and Resolutions/28.Implicit Data Type Conversion Issues.wmv 2MB
  43. 02.Why Query Plan Quality Matters/11.Under-estimates and Spills.wmv 2MB
  44. 04.Query Plan Quality Patterns and Resolutions/35.Distributed Queries.wmv 2MB
  45. 04.Query Plan Quality Patterns and Resolutions/18.Hidden Column Correlation.wmv 2MB
  46. 02.Why Query Plan Quality Matters/09.Operator Memory.wmv 2MB
  47. 01.Course Introduction/01.Course Introduction.wmv 2MB
  48. 02.Why Query Plan Quality Matters/04.Costing and Plan Quality.wmv 2MB
  49. 04.Query Plan Quality Patterns and Resolutions/03.Issue Prioritization.wmv 1MB
  50. 02.Why Query Plan Quality Matters/05.Operator Cost (1).wmv 1MB
  51. 02.Why Query Plan Quality Matters/01.Module Introduction.wmv 1MB
  52. 04.Query Plan Quality Patterns and Resolutions/05.Demo - Checking sys.databases.wmv 1MB
  53. 03.Identifying Query Plan Quality Issues/06.SQL Sentry Plan Explorer.wmv 1MB
  54. 04.Query Plan Quality Patterns and Resolutions/33.Hints.wmv 1MB
  55. 04.Query Plan Quality Patterns and Resolutions/29.Complex Predicates.wmv 1MB
  56. 03.Identifying Query Plan Quality Issues/02.Estimated Query Execution Plan.wmv 1MB
  57. 04.Query Plan Quality Patterns and Resolutions/37.Course Summary.wmv 1MB
  58. 04.Query Plan Quality Patterns and Resolutions/36.Query Optimizer Bugs.wmv 1MB
  59. 04.Query Plan Quality Patterns and Resolutions/20.Comparison of Intra-Table Columns.wmv 1MB
  60. 03.Identifying Query Plan Quality Issues/03.Actual Query Execution Plan.wmv 1MB
  61. 04.Query Plan Quality Patterns and Resolutions/22.Table Variable Usage.wmv 1MB
  62. 02.Why Query Plan Quality Matters/16.Excessive Resource Consumption.wmv 1MB
  63. 01.Course Introduction/02.Course Structure.wmv 906KB
  64. 03.Identifying Query Plan Quality Issues/01.Module Introduction.wmv 900KB
  65. 04.Query Plan Quality Patterns and Resolutions/01.Module Introduction.wmv 771KB
  66. 02.Why Query Plan Quality Matters/06.Operator Cost (2).wmv 742KB