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