Pluralsight SQL Server Common Query Tuning Problems And Solutions Part

Pluralsight SQL Server Common Query Tuning Problems And Solutions Part

Name	Pluralsight - SQL Server Common Query Tuning Problems And Solutions - Part 1	DOWNLOAD Copy Link
Total Size	784.0 MB
Total Files	61
Last Seen	2024-11-09 02:05
Hash	83FAB58CEBF90DF1642D646A09A4C9F0B266A362

/01. Course Introduction/
01_01-Course Introduction.mp4	2.7 MB
01_02-Course Scope.mp4	966.9 KB
01_03-Course Structure.mp4	1.8 MB
/02. Validating Assumptions/
02_01-Module Introduction.mp4	1.8 MB
02_02-Downstream Impact of Bad Assumptions.mp4	2.2 MB
02_03-Cardinality Estimation and Predicates.mp4	2.0 MB
02_04-Selectivity.mp4	1.2 MB
02_05-Query Cardinality Questions.mp4	2.0 MB
02_06-Cardinality Estimate Inputs.mp4	1.1 MB
02_07-Statistics.mp4	1.2 MB
02_08-Demo DBCC SHOW_STATISTICS STAT_HEADER.mp4	15.4 MB
02_09-Demo DBCC SHOW_STATISTICS DENSITY_VECTOR.mp4	8.1 MB
02_10-Demo DBCC SHOW_STATISTICS HISTOGRAM.mp4	20.2 MB
02_11-Demo Histogram Direct Step Hit.mp4	15.4 MB
02_12-Demo Scaling the Estimate.mp4	22.8 MB
02_13-Demo Histogram Intra-Step Hit.mp4	17.5 MB
02_14-Demo Density Vector With an Unknown Runtime Value.mp4	21.9 MB
02_15-Demo Parameter Sniffed Value Estimation.mp4	23.5 MB
02_16-Demo Distinct Value Estimation.mp4	11.3 MB
02_17-Impact to Query Execution and Performance.mp4	1.3 MB
02_18-Identifying Bad Assumptions - 1.mp4	1.4 MB
02_19-Demo Viewing Estimated Vs. Actual Row Counts.mp4	19.9 MB
02_20-Identifying Bad Assumptions - 2.mp4	1.4 MB
02_21-Demo sys.dm_exec_query_profiles.mp4	6.6 MB
02_22-Demo Root-level Skews via sys.dm_exec_query_stats.mp4	30.6 MB
02_23-What Variance is Problematic.mp4	1.6 MB
02_24-Module Summary.mp4	1.4 MB
/03. Troubleshooting Bad Assumptions/
03_01-Module Introduction.mp4	1.4 MB
03_02-Model Assumptions.mp4	2.5 MB
03_03-Demo Jagged Distributions.mp4	38.2 MB
03_04-Demo Correlated Predicates.mp4	29.6 MB
03_05-Demo Correlated Predicates in SQL Server 2014.mp4	32.7 MB
03_06-Demo Correlated Join Predicates, Independent Filter Predicates.mp4	21.8 MB
03_07-Demo Searching for Off-Histogram Values.mp4	22.4 MB
03_08-Demo Searching for Off-Histogram Values in SQL Server 2014.mp4	21.5 MB
03_09-Troubleshooting Questions - 1.mp4	1.9 MB
03_10-Demo Missing Statistics.mp4	19.5 MB
03_11-Demo Selectivity Guesses.mp4	24.8 MB
03_12-Demo Stale Statistics.mp4	27.3 MB
03_13-Demo Inadequate Sampling.mp4	38.0 MB
03_14-Demo Parameter Sensitivity.mp4	28.8 MB
03_15-Demo Table Variable Usage.mp4	11.9 MB
03_16-Demo MSTVF Usage - Part 1.mp4	22.3 MB
03_17-Demo MSTVF Usage - Part 2.mp4	13.9 MB
03_18-Demo MSTVF Usage - Part 3.mp4	7.6 MB
03_19-Troubleshooting Questions - 2.mp4	2.8 MB
03_20-Demo Data Type Conversions.mp4	25.3 MB
03_21-Demo Buried Predicates - Part 1.mp4	11.1 MB
03_22-Demo Buried Predicates - Part 2.mp4	12.3 MB
03_23-Module Summary.mp4	840.1 KB
/04. Tuning Imprecision Problems/
04_01-Module Introduction.mp4	2.0 MB
04_02-Demo SELECT .mp4	15.2 MB
04_03-Demo Unnecessary Sorts.mp4	12.6 MB
04_04-Demo Needless DISTINCT.mp4	14.6 MB
04_05-Demo UNION Vs. UNION ALL.mp4	15.5 MB
04_06-Demo Leading Wildcards.mp4	15.3 MB
04_07-Demo Hidden Cartesian Products.mp4	11.9 MB
04_08-Demo Data Type Conversion Issues.mp4	18.6 MB
04_09-Demo Redundant Logic and Overlapping Object References.mp4	19.3 MB
04_10-Module and Course Summary.mp4	1.3 MB
/Exercise files/
sql-server-common-query-tuning-problems-solutions.zip	2.1 MB
Total files 61