589689.xyz

Pluralsight - SQL Server Common Query Tuning Problems And Solutions - Part 1

  • 收录时间:2018-02-25 04:16:07
  • 文件大小:748MB
  • 下载次数:140
  • 最近下载:2021-01-12 18:28:30
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 03. Troubleshooting Bad Assumptions/03_03-Demo Jagged Distributions.mp4 36MB
  2. 03. Troubleshooting Bad Assumptions/03_13-Demo Inadequate Sampling.mp4 36MB
  3. 03. Troubleshooting Bad Assumptions/03_05-Demo Correlated Predicates in SQL Server 2014.mp4 31MB
  4. 02. Validating Assumptions/02_22-Demo Root-level Skews via sys.dm_exec_query_stats.mp4 29MB
  5. 03. Troubleshooting Bad Assumptions/03_04-Demo Correlated Predicates.mp4 28MB
  6. 03. Troubleshooting Bad Assumptions/03_14-Demo Parameter Sensitivity.mp4 27MB
  7. 03. Troubleshooting Bad Assumptions/03_12-Demo Stale Statistics.mp4 26MB
  8. 03. Troubleshooting Bad Assumptions/03_20-Demo Data Type Conversions.mp4 24MB
  9. 03. Troubleshooting Bad Assumptions/03_11-Demo Selectivity Guesses.mp4 24MB
  10. 02. Validating Assumptions/02_15-Demo Parameter Sniffed Value Estimation.mp4 22MB
  11. 02. Validating Assumptions/02_12-Demo Scaling the Estimate.mp4 22MB
  12. 03. Troubleshooting Bad Assumptions/03_07-Demo Searching for Off-Histogram Values.mp4 21MB
  13. 03. Troubleshooting Bad Assumptions/03_16-Demo MSTVF Usage - Part 1.mp4 21MB
  14. 02. Validating Assumptions/02_14-Demo Density Vector With an Unknown Runtime Value.mp4 21MB
  15. 03. Troubleshooting Bad Assumptions/03_06-Demo Correlated Join Predicates, Independent Filter Predicates.mp4 21MB
  16. 03. Troubleshooting Bad Assumptions/03_08-Demo Searching for Off-Histogram Values in SQL Server 2014.mp4 20MB
  17. 02. Validating Assumptions/02_10-Demo DBCC SHOW_STATISTICS HISTOGRAM.mp4 19MB
  18. 02. Validating Assumptions/02_19-Demo Viewing Estimated Vs. Actual Row Counts.mp4 19MB
  19. 03. Troubleshooting Bad Assumptions/03_10-Demo Missing Statistics.mp4 19MB
  20. 04. Tuning Imprecision Problems/04_09-Demo Redundant Logic and Overlapping Object References.mp4 18MB
  21. 04. Tuning Imprecision Problems/04_08-Demo Data Type Conversion Issues.mp4 18MB
  22. 02. Validating Assumptions/02_13-Demo Histogram Intra-Step Hit.mp4 17MB
  23. 04. Tuning Imprecision Problems/04_05-Demo UNION Vs. UNION ALL.mp4 15MB
  24. 02. Validating Assumptions/02_11-Demo Histogram Direct Step Hit.mp4 15MB
  25. 02. Validating Assumptions/02_08-Demo DBCC SHOW_STATISTICS STAT_HEADER.mp4 15MB
  26. 04. Tuning Imprecision Problems/04_06-Demo Leading Wildcards.mp4 15MB
  27. 04. Tuning Imprecision Problems/04_02-Demo SELECT .mp4 14MB
  28. 04. Tuning Imprecision Problems/04_04-Demo Needless DISTINCT.mp4 14MB
  29. 03. Troubleshooting Bad Assumptions/03_17-Demo MSTVF Usage - Part 2.mp4 13MB
  30. 04. Tuning Imprecision Problems/04_03-Demo Unnecessary Sorts.mp4 12MB
  31. 03. Troubleshooting Bad Assumptions/03_22-Demo Buried Predicates - Part 2.mp4 12MB
  32. 04. Tuning Imprecision Problems/04_07-Demo Hidden Cartesian Products.mp4 11MB
  33. 03. Troubleshooting Bad Assumptions/03_15-Demo Table Variable Usage.mp4 11MB
  34. 02. Validating Assumptions/02_16-Demo Distinct Value Estimation.mp4 11MB
  35. 03. Troubleshooting Bad Assumptions/03_21-Demo Buried Predicates - Part 1.mp4 11MB
  36. 02. Validating Assumptions/02_09-Demo DBCC SHOW_STATISTICS DENSITY_VECTOR.mp4 8MB
  37. 03. Troubleshooting Bad Assumptions/03_18-Demo MSTVF Usage - Part 3.mp4 7MB
  38. 02. Validating Assumptions/02_21-Demo sys.dm_exec_query_profiles.mp4 6MB
  39. 03. Troubleshooting Bad Assumptions/03_19-Troubleshooting Questions - 2.mp4 3MB
  40. 01. Course Introduction/01_01-Course Introduction.mp4 3MB
  41. 03. Troubleshooting Bad Assumptions/03_02-Model Assumptions.mp4 2MB
  42. 02. Validating Assumptions/02_02-Downstream Impact of Bad Assumptions.mp4 2MB
  43. Exercise files/sql-server-common-query-tuning-problems-solutions.zip 2MB
  44. 04. Tuning Imprecision Problems/04_01-Module Introduction.mp4 2MB
  45. 02. Validating Assumptions/02_03-Cardinality Estimation and Predicates.mp4 2MB
  46. 02. Validating Assumptions/02_05-Query Cardinality Questions.mp4 2MB
  47. 03. Troubleshooting Bad Assumptions/03_09-Troubleshooting Questions - 1.mp4 2MB
  48. 01. Course Introduction/01_03-Course Structure.mp4 2MB
  49. 02. Validating Assumptions/02_01-Module Introduction.mp4 2MB
  50. 02. Validating Assumptions/02_23-What Variance is Problematic.mp4 1MB
  51. 02. Validating Assumptions/02_18-Identifying Bad Assumptions - 1.mp4 1MB
  52. 02. Validating Assumptions/02_24-Module Summary.mp4 1MB
  53. 03. Troubleshooting Bad Assumptions/03_01-Module Introduction.mp4 1MB
  54. 02. Validating Assumptions/02_20-Identifying Bad Assumptions - 2.mp4 1MB
  55. 04. Tuning Imprecision Problems/04_10-Module and Course Summary.mp4 1MB
  56. 02. Validating Assumptions/02_17-Impact to Query Execution and Performance.mp4 1MB
  57. 02. Validating Assumptions/02_07-Statistics.mp4 1MB
  58. 02. Validating Assumptions/02_04-Selectivity.mp4 1MB
  59. 02. Validating Assumptions/02_06-Cardinality Estimate Inputs.mp4 1MB
  60. 01. Course Introduction/01_02-Course Scope.mp4 944KB
  61. 03. Troubleshooting Bad Assumptions/03_23-Module Summary.mp4 820KB