SQL Server Query Plan Analysis | 4DF7B9704DCF503ECEC6DF6C08FECF02A16299DD

SQL Server Query Plan Analysis

Name	SQL Server - Query Plan Analysis	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	391.7 MB
Total Files	98
Hash	4DF7B9704DCF503ECEC6DF6C08FECF02A16299DD

/02.Capturing Query Execution Plans/
03.Demo - Capturing a Plan.wmv	22.6 MB
10.Demo - Graphical Showplan.wmv	18.5 MB
14.Demo - Estimated vs. Actual.wmv	18.1 MB
08.Demo - Using Extended Events to Capture Execution Plans.wmv	8.9 MB
12.Demo - SQL Sentry Plan Explorer.wmv	7.7 MB
06.Demo - DMOs.wmv	6.8 MB
02.Capturing a Plan.wmv	2.2 MB
13.Estimated vs. Actual.wmv	2.1 MB
05.DMOs.wmv	1.7 MB
09.Graphical Showplan.wmv	1.7 MB
04.Why Deprecate.wmv	1.3 MB
11.SQL Sentry Plan Explorer.wmv	979.1 KB
07.SQL Trace and Extended Events.wmv	937.0 KB
01.Module Introduction.wmv	919.0 KB
/03.Interpreting Query Execution Plans/
06.Demo - Operator Cost.wmv	21.3 MB
09.Demo - Operator Memory.wmv	13.2 MB
08.Operator Memory (2).wmv	1.6 MB
02.Iterators - Operators.wmv	1.5 MB
01.Module Introduction.wmv	1.1 MB
07.Operator Memory (1).wmv	1.1 MB
03.Query Tree.wmv	1.1 MB
04.Operator Cost (1).wmv	919.0 KB
05.Operator Cost (2).wmv	846.9 KB
/04.Common Operators/
16.Demo - Hash Match Join.wmv	15.8 MB
12.Demo - Nested Loop.wmv	12.9 MB
18.Demo - Filter.wmv	10.1 MB
05.Demo - Index Seeks.wmv	8.7 MB
24.Demo - Sort.wmv	8.4 MB
07.Demo - Lookups.wmv	7.7 MB
44.Demo - Segment and Sequence Project.wmv	7.4 MB
31.Demo - Assert.wmv	6.7 MB
40.Demo - Merge Interval.wmv	6.7 MB
36.Demo - Exchange Operators.wmv	5.7 MB
29.Demo - Constant Scan.wmv	5.6 MB
22.Demo - Hash Match Aggregate.wmv	4.8 MB
20.Demo - Stream Aggregate.wmv	4.8 MB
42.Demo - Concatenation.wmv	4.7 MB
38.Demo - Bitmap.wmv	4.6 MB
03.Demo - Table and Index Scans.wmv	4.6 MB
27.Demo - Eager Spool.wmv	4.3 MB
14.Demo - Merge Join.wmv	4.1 MB
33.Demo - Compute Scalar.wmv	3.3 MB
09.Outer - Inner Terminology.wmv	2.5 MB
10.Demo - Outer-Inner Terminology.wmv	2.4 MB
26.Eager Spool and 'Halloween Protection'.wmv	2.2 MB
08.Join Considerations.wmv	2.0 MB
06.Lookups.wmv	1.7 MB
02.Table and Index Scans.wmv	1.6 MB
15.Hash Match Join.wmv	1.5 MB
25.Spools.wmv	1.4 MB
01.Module Introduction.wmv	1.3 MB
17.Filter.wmv	1.3 MB
13.Merge Join.wmv	1.3 MB
11.Nested Loop.wmv	1.2 MB
35.Exchange Operators.wmv	1.1 MB
32.Compute Scalar.wmv	1.1 MB
21.Hash Match (Aggregate).wmv	1.0 MB
19.Stream Aggregate.wmv	1.0 MB
28.Constant Scan.wmv	852.9 KB
43.Segment and Sequence Project.wmv	777.8 KB
34.Identifying Parallelism in the Plan.wmv	729.7 KB
04.Index Seeks.wmv	687.6 KB
37.Bitmap.wmv	534.4 KB
39.Merge Interval.wmv	435.2 KB
30.Assert.wmv	411.2 KB
41.Concatenation.wmv	270.0 KB
23.Sort.wmv	1.0 KB
/05.Noteworthy Patterns/
25.Demo - Parameter Sniffing.wmv	15.2 MB
21.Demo - PlanAffectingConvert.wmv	13.4 MB
09.Demo - Hash Join Spills.wmv	12.3 MB
17.Demo - Data Modification Plan Patterns.wmv	9.3 MB
07.Demo - Merge Join Overhead.wmv	8.4 MB
03.Demo - Missing index warnings.wmv	6.7 MB
02.The 'Basics'.wmv	1.8 MB
05.Nested Loop Patterns.wmv	1.7 MB
24.Parameter Sniffing.wmv	1.6 MB
27.Course Summary.wmv	1.5 MB
11.Sort Patterns.wmv	1.3 MB
26.Columnstore Index Execution Mode.wmv	1.3 MB
19.Data Type Conversions.wmv	1.3 MB
08.Hash Join Patterns.wmv	1.2 MB
01.Module Introduction.wmv	1.2 MB
14.Spool Overhead.wmv	1.1 MB
04.Lookups.wmv	1.1 MB
06.Merge Join Patterns.wmv	1.1 MB
23.ColumnsWithNoStatistics Warning.wmv	1.1 MB
12.Aggregates.wmv	997.1 KB
10.Stop-and-Go Operators.wmv	843.9 KB
15.Parallelism Performance Aspects.wmv	795.8 KB
22.NoJoinPredicateWarning.wmv	783.8 KB
13.Predicates.wmv	771.8 KB
16.Data Modification Plan Patterns.wmv	729.7 KB
18.Cardinality Estimate Issues.wmv	723.7 KB
20.PlanAffectingConvert.wmv	498.3 KB
/01.Course Introduction/
02.Why Do We Care About QPs.wmv	1.6 MB
03.What Doesn't a Query Plan Tell Us.wmv	1.6 MB
01.Course Introduction.wmv	1.6 MB
04.Course Structure.wmv	810.8 KB
Total files 98