Understanding Execution Plans and Indexes in SQL Server

سرفصل های دوره

Learn Basic to Advanced Level Training of Indexes and Execution Plans using T-SQL Commands in Microsoft SQL Server

1 - Introduction

1 - Introduction

2 - Page in SQL Server

3 - Extent in SQL Server

4 - Heap in SQL Server

5 - Clustered Index

6 - Non Clustered Index

7 - Heap with Non Clustered Index

8 - Indexes are not very Deep

9 - Composite Index Part 1

10 - Composite Index Part 2

11 - Index Fragmentation

12 - More on Fragmentation

13 - Index Creation using TSQL Commands

14 - Index Rebuild and ReOrganize

15 - Index Fragmentation Practical

16 - FillFactor

17 - TSQL Command to introduce FillFactor in an Index.html

18 - Included Columns

19 - Data Type on Clustered Index

2 - Execution Plans

20 - What are Estimated Actual Execution Plans along with Statistics

21 - Download and Restore AdventureWorks Database

22 - Table Scan Operator

23 - Index Scan Operator

24 - Index Seek Operator

25 - Key Lookup RowID Lookup Nested Loop Operators

26 - Index supports Wild Card

27 - Sort in Execution Plan

28 - Merge Join Operator

29 - Hash JoinMerge Join Nested Loop Operators

30 - Compute Scalar Operator

31 - Stream and Hash Aggregate Operators

32 - Subtree Cost of Stream and Hash Aggregate

33 - Semi Joins Anti Semi Joins in Execution Plan

34 - Merge using Left Anti Semi Join in Execution Plan

35 - Execution Plan of Insert Operation

36 - Passthrough property in Nested Loop

37 - Execution Plan of Delete Operation

38 - Parallelism in Execution Plan

39 - Distribute Stream Gather Stream Repartition Stream

40 - Segment Operator Sequence Project Operators in Execution Plan

41 - Lazy Spool in Execution Plan

42 - Eager Spool and Halloween Problem Practical

3 - Patterns to Notice in Execution Plans

43 - Parameter Sniffing vs Parameter Sensitive Plan Optimization in Sql Server 2022

44 - Parameter Sniffing vs Parameter Sensitive Plan Optimization Practical

45 - Merge Join Patterns

46 - Hash Join Patterns

47 - Key Lookup Patterns

48 - Sort Aggregate Parallelism Patterns

49 - Warnings in Execution Plan

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy