آموزش کوئری ها در sql server

Course Introduction 01:02 Why Do We Care About QPs? 01:00 What Doesn't a Query Plan Tell Us? 01:03 Course Structure 00:36 Capturing Query Execution Plans 00:31:06 Module Introduction 00:37 Capturing a Plan 01:34 Demo: Capturing a Plan 05:02 Why Deprecate? 00:52 DMOs 01:12 Demo: DMOs 02:57 SQL Trace and Extended Events 00:39 Demo: Using Extended Events to Capture Execution Plans 03:29 Graphical Showplan 01:12 Demo: Graphical Showplan 04:36 SQL Sentry Plan Explorer 00:43 Demo: SQL Sentry Plan Explorer 02:52 Estimated vs. Actual 01:26 Demo: Estimated vs. Actual 03:55 Interpreting Query Execution Plans 00:13:24 Module Introduction 00:45 Iterators / Operators 01:04 Query Tree 00:42 Operator Cost (1) 00:39 Operator Cost (2) 00:36 Demo: Operator Cost 04:32 Operator Memory (1) 00:45 Operator Memory (2) 01:07 Demo: Operator Memory 03:14 Common Operators 00:54:29 Module Introduction 00:55 Table and Index Scans 01:09 Demo: Table and Index Scans 01:40 Index Seeks 00:29 Demo: Index Seeks 01:53 Lookups 01:15 Demo: Lookups 02:13 Join Considerations 01:21 Outer / Inner Terminology 01:44 Demo: Outer / Inner Terminology 00:59 Nested Loop 00:50 Demo: Nested Loop 03:08 Merge Join 00:54 Demo: Merge Join 01:34 Hash Match Join 01:01 Demo: Hash Match Join 03:06 Filter 00:53 Demo: Filter 02:19 Stream Aggregate 00:44 Demo: Stream Aggregate 01:42 Hash Match (Aggregate) 00:42 Demo: Hash Match Aggregate 01:37 Sort 00:32 Demo: Sort 02:09 Spools 01:00 Eager Spool and 'Halloween Protection' 01:33 Demo: Eager Spool 01:26 Constant Scan 00:36 Demo: Constant Scan 01:02 Assert 00:18 Demo: Assert 01:29 Compute Scalar 00:40 Demo: Compute Scalar 00:52 Identifying Parallelism in the Plan 00:30 Exchange Operators 00:43 Demo: Exchange Operators 01:14 Bitmap 00:22 Demo: Bitmap 01:28 Merge Interval 00:19 Demo: Merge Interval 01:49 Concatenation 00:12 Demo: Concatenation 01:14 Segment and Sequence Project 00:31 Demo: Segment and Sequence Project 02:22 Noteworthy Patterns 00:31:32 Module Introduction 00:45 The 'Basics' 01:15 Demo: Missing index warnings 02:05 Lookups 00:46 Nested Loop Patterns 01:14 Merge Join Patterns 00:46 Demo: Merge Join Overhead 01:58 Hash Join Patterns 00:51 Demo: Hash Join Spills 02:54 Stop-and-Go Operators 00:36 Sort Patterns 00:58 Aggregates 00:43 Predicates 00:34 Spool Overhead 00:49 Parallelism Performance Aspects 00:34 Data Modification Plan Patterns 00:30 Demo: Data Modification Plan Patterns 02:06 Cardinality Estimate Issues 00:30 Data Type Conversions 00:54 PlanAffectingConvert 00:21 Demo: PlanAffectingConvert 02:57 NoJoinPredicateWarning 00:32 ColumnsWithNoStatistics Warning 00:42 Parameter Sniffing 01:08 Demo: Parameter Sniffing 03:21 Columnstore Index Execution Mode 00:51