资源详情

返回首页 | 相关搜索
Pluralsight - SQL Server Common Query Tuning Problems And Solutions - Part 1
大小 747.64 MB
文件数 61
Info Hash: 83FAB58CEBF90DF1642D646A09A4C9F0B266A362
收录时间 2025-12-24 21:34:13
更新时间 2025-12-24 21:34:13
文件列表 (61)
01. Course Introduction/01_01-Course Introduction.mp4
2.53 MB
01. Course Introduction/01_02-Course Scope.mp4
944.2 KB
01. Course Introduction/01_03-Course Structure.mp4
1.74 MB
02. Validating Assumptions/02_01-Module Introduction.mp4
1.68 MB
02. Validating Assumptions/02_02-Downstream Impact of Bad Assumptions.mp4
2.08 MB
02. Validating Assumptions/02_03-Cardinality Estimation and Predicates.mp4
1.91 MB
02. Validating Assumptions/02_04-Selectivity.mp4
1.12 MB
02. Validating Assumptions/02_05-Query Cardinality Questions.mp4
1.88 MB
02. Validating Assumptions/02_06-Cardinality Estimate Inputs.mp4
1.08 MB
02. Validating Assumptions/02_07-Statistics.mp4
1.16 MB
02. Validating Assumptions/02_08-Demo DBCC SHOW_STATISTICS STAT_HEADER.mp4
14.67 MB
02. Validating Assumptions/02_09-Demo DBCC SHOW_STATISTICS DENSITY_VECTOR.mp4
7.71 MB
02. Validating Assumptions/02_10-Demo DBCC SHOW_STATISTICS HISTOGRAM.mp4
19.23 MB
02. Validating Assumptions/02_11-Demo Histogram Direct Step Hit.mp4
14.68 MB
02. Validating Assumptions/02_12-Demo Scaling the Estimate.mp4
21.73 MB
02. Validating Assumptions/02_13-Demo Histogram Intra-Step Hit.mp4
16.71 MB
02. Validating Assumptions/02_14-Demo Density Vector With an Unknown Runtime Value.mp4
20.91 MB
02. Validating Assumptions/02_15-Demo Parameter Sniffed Value Estimation.mp4
22.46 MB
02. Validating Assumptions/02_16-Demo Distinct Value Estimation.mp4
10.8 MB
02. Validating Assumptions/02_17-Impact to Query Execution and Performance.mp4
1.2 MB
02. Validating Assumptions/02_18-Identifying Bad Assumptions - 1.mp4
1.38 MB
02. Validating Assumptions/02_19-Demo Viewing Estimated Vs. Actual Row Counts.mp4
19.02 MB
02. Validating Assumptions/02_20-Identifying Bad Assumptions - 2.mp4
1.31 MB
02. Validating Assumptions/02_21-Demo sys.dm_exec_query_profiles.mp4
6.32 MB
02. Validating Assumptions/02_22-Demo Root-level Skews via sys.dm_exec_query_stats.mp4
29.2 MB
02. Validating Assumptions/02_23-What Variance is Problematic.mp4
1.5 MB
02. Validating Assumptions/02_24-Module Summary.mp4
1.35 MB
03. Troubleshooting Bad Assumptions/03_01-Module Introduction.mp4
1.31 MB
03. Troubleshooting Bad Assumptions/03_02-Model Assumptions.mp4
2.43 MB
03. Troubleshooting Bad Assumptions/03_03-Demo Jagged Distributions.mp4
36.46 MB
03. Troubleshooting Bad Assumptions/03_04-Demo Correlated Predicates.mp4
28.23 MB
03. Troubleshooting Bad Assumptions/03_05-Demo Correlated Predicates in SQL Server 2014.mp4
31.14 MB
03. Troubleshooting Bad Assumptions/03_06-Demo Correlated Join Predicates, Independent Filter Predicates.mp4
20.82 MB
03. Troubleshooting Bad Assumptions/03_07-Demo Searching for Off-Histogram Values.mp4
21.35 MB
03. Troubleshooting Bad Assumptions/03_08-Demo Searching for Off-Histogram Values in SQL Server 2014.mp4
20.47 MB
03. Troubleshooting Bad Assumptions/03_09-Troubleshooting Questions - 1.mp4
1.84 MB
03. Troubleshooting Bad Assumptions/03_10-Demo Missing Statistics.mp4
18.58 MB
03. Troubleshooting Bad Assumptions/03_11-Demo Selectivity Guesses.mp4
23.63 MB
03. Troubleshooting Bad Assumptions/03_12-Demo Stale Statistics.mp4
26.07 MB
03. Troubleshooting Bad Assumptions/03_13-Demo Inadequate Sampling.mp4
36.22 MB
03. Troubleshooting Bad Assumptions/03_14-Demo Parameter Sensitivity.mp4
27.42 MB
03. Troubleshooting Bad Assumptions/03_15-Demo Table Variable Usage.mp4
11.3 MB
03. Troubleshooting Bad Assumptions/03_16-Demo MSTVF Usage - Part 1.mp4
21.26 MB
03. Troubleshooting Bad Assumptions/03_17-Demo MSTVF Usage - Part 2.mp4
13.22 MB
03. Troubleshooting Bad Assumptions/03_18-Demo MSTVF Usage - Part 3.mp4
7.25 MB
03. Troubleshooting Bad Assumptions/03_19-Troubleshooting Questions - 2.mp4
2.66 MB
03. Troubleshooting Bad Assumptions/03_20-Demo Data Type Conversions.mp4
24.17 MB
03. Troubleshooting Bad Assumptions/03_21-Demo Buried Predicates - Part 1.mp4
10.6 MB
03. Troubleshooting Bad Assumptions/03_22-Demo Buried Predicates - Part 2.mp4
11.75 MB
03. Troubleshooting Bad Assumptions/03_23-Module Summary.mp4
820.44 KB
04. Tuning Imprecision Problems/04_01-Module Introduction.mp4
1.91 MB
04. Tuning Imprecision Problems/04_02-Demo SELECT .mp4
14.45 MB
04. Tuning Imprecision Problems/04_03-Demo Unnecessary Sorts.mp4
11.99 MB
04. Tuning Imprecision Problems/04_04-Demo Needless DISTINCT.mp4
13.95 MB
04. Tuning Imprecision Problems/04_05-Demo UNION Vs. UNION ALL.mp4
14.83 MB
04. Tuning Imprecision Problems/04_06-Demo Leading Wildcards.mp4
14.55 MB
04. Tuning Imprecision Problems/04_07-Demo Hidden Cartesian Products.mp4
11.34 MB
04. Tuning Imprecision Problems/04_08-Demo Data Type Conversion Issues.mp4
17.7 MB
04. Tuning Imprecision Problems/04_09-Demo Redundant Logic and Overlapping Object References.mp4
18.39 MB
04. Tuning Imprecision Problems/04_10-Module and Course Summary.mp4
1.26 MB
Exercise files/sql-server-common-query-tuning-problems-solutions.zip
2.02 MB
相关资源

免责声明

本网站仅提供DHT网络资源索引服务，不存储任何资源文件。所有资源均来自DHT网络，本站无法控制其内容。请遵守当地法律法规，合理使用网络资源。如涉及版权问题，请联系 fuckatgfw@protonmail.com。

© 2025 鹿鹿堂