Pluralsight - SQL Server Common Query Tuning Problems And Solutions - Part 1
File List
- 03. Troubleshooting Bad Assumptions/03_03-Demo Jagged Distributions.mp4 36.5 MB
- 03. Troubleshooting Bad Assumptions/03_13-Demo Inadequate Sampling.mp4 36.2 MB
- 03. Troubleshooting Bad Assumptions/03_05-Demo Correlated Predicates in SQL Server 2014.mp4 31.1 MB
- 02. Validating Assumptions/02_22-Demo Root-level Skews via sys.dm_exec_query_stats.mp4 29.2 MB
- 03. Troubleshooting Bad Assumptions/03_04-Demo Correlated Predicates.mp4 28.2 MB
- 03. Troubleshooting Bad Assumptions/03_14-Demo Parameter Sensitivity.mp4 27.4 MB
- 03. Troubleshooting Bad Assumptions/03_12-Demo Stale Statistics.mp4 26.1 MB
- 03. Troubleshooting Bad Assumptions/03_20-Demo Data Type Conversions.mp4 24.2 MB
- 03. Troubleshooting Bad Assumptions/03_11-Demo Selectivity Guesses.mp4 23.6 MB
- 02. Validating Assumptions/02_15-Demo Parameter Sniffed Value Estimation.mp4 22.5 MB
- 02. Validating Assumptions/02_12-Demo Scaling the Estimate.mp4 21.7 MB
- 03. Troubleshooting Bad Assumptions/03_07-Demo Searching for Off-Histogram Values.mp4 21.4 MB
- 03. Troubleshooting Bad Assumptions/03_16-Demo MSTVF Usage - Part 1.mp4 21.3 MB
- 02. Validating Assumptions/02_14-Demo Density Vector With an Unknown Runtime Value.mp4 20.9 MB
- 03. Troubleshooting Bad Assumptions/03_06-Demo Correlated Join Predicates, Independent Filter Predicates.mp4 20.8 MB
- 03. Troubleshooting Bad Assumptions/03_08-Demo Searching for Off-Histogram Values in SQL Server 2014.mp4 20.5 MB
- 02. Validating Assumptions/02_10-Demo DBCC SHOW_STATISTICS HISTOGRAM.mp4 19.2 MB
- 02. Validating Assumptions/02_19-Demo Viewing Estimated Vs. Actual Row Counts.mp4 19.0 MB
- 03. Troubleshooting Bad Assumptions/03_10-Demo Missing Statistics.mp4 18.6 MB
- 04. Tuning Imprecision Problems/04_09-Demo Redundant Logic and Overlapping Object References.mp4 18.4 MB
- 04. Tuning Imprecision Problems/04_08-Demo Data Type Conversion Issues.mp4 17.7 MB
- 02. Validating Assumptions/02_13-Demo Histogram Intra-Step Hit.mp4 16.7 MB
- 04. Tuning Imprecision Problems/04_05-Demo UNION Vs. UNION ALL.mp4 14.8 MB
- 02. Validating Assumptions/02_11-Demo Histogram Direct Step Hit.mp4 14.7 MB
- 02. Validating Assumptions/02_08-Demo DBCC SHOW_STATISTICS STAT_HEADER.mp4 14.7 MB
- 04. Tuning Imprecision Problems/04_06-Demo Leading Wildcards.mp4 14.6 MB
- 04. Tuning Imprecision Problems/04_02-Demo SELECT .mp4 14.5 MB
- 04. Tuning Imprecision Problems/04_04-Demo Needless DISTINCT.mp4 13.9 MB
- 03. Troubleshooting Bad Assumptions/03_17-Demo MSTVF Usage - Part 2.mp4 13.2 MB
- 04. Tuning Imprecision Problems/04_03-Demo Unnecessary Sorts.mp4 12.0 MB
- 03. Troubleshooting Bad Assumptions/03_22-Demo Buried Predicates - Part 2.mp4 11.7 MB
- 04. Tuning Imprecision Problems/04_07-Demo Hidden Cartesian Products.mp4 11.3 MB
- 03. Troubleshooting Bad Assumptions/03_15-Demo Table Variable Usage.mp4 11.3 MB
- 02. Validating Assumptions/02_16-Demo Distinct Value Estimation.mp4 10.8 MB
- 03. Troubleshooting Bad Assumptions/03_21-Demo Buried Predicates - Part 1.mp4 10.6 MB
- 02. Validating Assumptions/02_09-Demo DBCC SHOW_STATISTICS DENSITY_VECTOR.mp4 7.7 MB
- 03. Troubleshooting Bad Assumptions/03_18-Demo MSTVF Usage - Part 3.mp4 7.2 MB
- 02. Validating Assumptions/02_21-Demo sys.dm_exec_query_profiles.mp4 6.3 MB
- 03. Troubleshooting Bad Assumptions/03_19-Troubleshooting Questions - 2.mp4 2.7 MB
- 01. Course Introduction/01_01-Course Introduction.mp4 2.5 MB
- 03. Troubleshooting Bad Assumptions/03_02-Model Assumptions.mp4 2.4 MB
- 02. Validating Assumptions/02_02-Downstream Impact of Bad Assumptions.mp4 2.1 MB
- Exercise files/sql-server-common-query-tuning-problems-solutions.zip 2.0 MB
- 04. Tuning Imprecision Problems/04_01-Module Introduction.mp4 1.9 MB
- 02. Validating Assumptions/02_03-Cardinality Estimation and Predicates.mp4 1.9 MB
- 02. Validating Assumptions/02_05-Query Cardinality Questions.mp4 1.9 MB
- 03. Troubleshooting Bad Assumptions/03_09-Troubleshooting Questions - 1.mp4 1.8 MB
- 01. Course Introduction/01_03-Course Structure.mp4 1.7 MB
- 02. Validating Assumptions/02_01-Module Introduction.mp4 1.7 MB
- 02. Validating Assumptions/02_23-What Variance is Problematic.mp4 1.5 MB
- 02. Validating Assumptions/02_18-Identifying Bad Assumptions - 1.mp4 1.4 MB
- 02. Validating Assumptions/02_24-Module Summary.mp4 1.3 MB
- 03. Troubleshooting Bad Assumptions/03_01-Module Introduction.mp4 1.3 MB
- 02. Validating Assumptions/02_20-Identifying Bad Assumptions - 2.mp4 1.3 MB
- 04. Tuning Imprecision Problems/04_10-Module and Course Summary.mp4 1.3 MB
- 02. Validating Assumptions/02_17-Impact to Query Execution and Performance.mp4 1.2 MB
- 02. Validating Assumptions/02_07-Statistics.mp4 1.2 MB
- 02. Validating Assumptions/02_04-Selectivity.mp4 1.1 MB
- 02. Validating Assumptions/02_06-Cardinality Estimate Inputs.mp4 1.1 MB
- 01. Course Introduction/01_02-Course Scope.mp4 944.2 KB
- 03. Troubleshooting Bad Assumptions/03_23-Module Summary.mp4 820.4 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via anywarmservice[AT]gmail.com. Remember to include the full url in your complaint.