Sql Serrver Troubleshooting Query Plan Quality Issues | 3D417E630635F605705F0CAF9E90CA4881836E54

Sql Serrver Troubleshooting Query Plan Quality Issues

Name	Sql Serrver - Troubleshooting Query Plan Quality Issues	DOWNLOAD Copy Link
Total Size	415.7 MB
Total Files	66
Hash	3D417E630635F605705F0CAF9E90CA4881836E54

/04.Query Plan Quality Patterns and Resolutions/
19.Demo - Hidden Column Correlation.wmv	35.2 MB
10.Demo - Manual Statistics Updates.wmv	29.9 MB
07.Demo - Resolving NO_RECOMPUTE Issues.wmv	20.2 MB
11.Demo - Using Trace Flag 2371.wmv	17.8 MB
15.Demo - Using FULLSCAN Manual Statistics Updates.wmv	17.2 MB
27.Demo - Parameter Sniffing.wmv	15.3 MB
34.Demo - Hints.wmv	14.1 MB
17.Demo - Filtered Statistics Threshold Update Problem.wmv	12.4 MB
16.Demo - Creating Filtered Statistics.wmv	12.0 MB
30.Demo - Complex Predicates.wmv	10.2 MB
32.Demo - Query Complexity.wmv	9.7 MB
23.Demo - Table Variable Usage.wmv	8.3 MB
14.Demo - Using sys.dm_db_stats_properties.wmv	7.5 MB
25.Demo - MSTV UDFs.wmv	7.1 MB
21.Demo - Comparison of Intra-Table Columns.wmv	5.9 MB
13.Demo - Using DBCC SHOW_STATISTICS.wmv	5.9 MB
09.Demo - Checking STATS_DATE.wmv	4.4 MB
06.Demo - Checking sys.stats and sp_helpstats.wmv	4.1 MB
31.Query Complexity.wmv	3.2 MB
04.Missing or Stale Statistics (1).wmv	2.5 MB
12.Sampling Issues.wmv	2.5 MB
26.Parameter Sniffing.wmv	2.3 MB
08.Missing or Stale Statistics (2).wmv	2.1 MB
02.Before Jumping In....wmv	2.0 MB
24.Scalar and MSTV UDFs.wmv	2.0 MB
28.Implicit Data Type Conversion Issues.wmv	1.8 MB
35.Distributed Queries.wmv	1.7 MB
18.Hidden Column Correlation.wmv	1.7 MB
03.Issue Prioritization.wmv	1.5 MB
05.Demo - Checking sys.databases.wmv	1.4 MB
33.Hints.wmv	1.4 MB
29.Complex Predicates.wmv	1.4 MB
37.Course Summary.wmv	1.3 MB
36.Query Optimizer Bugs.wmv	1.3 MB
20.Comparison of Intra-Table Columns.wmv	1.3 MB
22.Table Variable Usage.wmv	1.2 MB
01.Module Introduction.wmv	789.8 KB
/02.Why Query Plan Quality Matters/
08.Demo - Operator Cost.wmv	32.7 MB
12.Demo - Under-estimates and Spills.wmv	15.3 MB
14.Demo - Over-estimates and Concurrency.wmv	14.9 MB
02.Which is the 'Good' Plan.wmv	4.4 MB
15.Impacted Query Optimizer Decisions.wmv	3.3 MB
03.Cardinality Estimates.wmv	2.6 MB
10.Memory Operators.wmv	2.4 MB
07.Operator Cost (3).wmv	2.1 MB
13.Over-estimates and Concurrency.wmv	2.1 MB
11.Under-estimates and Spills.wmv	1.8 MB
09.Operator Memory.wmv	1.7 MB
04.Costing and Plan Quality.wmv	1.6 MB
05.Operator Cost (1).wmv	1.5 MB
01.Module Introduction.wmv	1.5 MB
16.Excessive Resource Consumption.wmv	1.1 MB
06.Operator Cost (2).wmv	759.7 KB
/03.Identifying Query Plan Quality Issues/
11.Demo - Row Count Statistics in sys.dm_exec_query_stats.wmv	14.3 MB
05.Demo - Capturing an Actual Plan.wmv	10.8 MB
09.Demo - Inaccurate Cardinality Estimate Event Capture.wmv	8.0 MB
10.Demo - ConvertIssue Plan Attributes.wmv	6.3 MB
07.Demo - SQL Sentry Plan Explorer.wmv	4.2 MB
08.SQL Server 2012 Supplemental Information.wmv	2.4 MB
04.Capturing an Actual Plan.wmv	1.9 MB
06.SQL Sentry Plan Explorer.wmv	1.4 MB
02.Estimated Query Execution Plan.wmv	1.4 MB
03.Actual Query Execution Plan.wmv	1.2 MB
01.Module Introduction.wmv	922.0 KB
/01.Course Introduction/
01.Course Introduction.wmv	1.7 MB
02.Course Structure.wmv	928.0 KB
Total files 66