Understanding Execution Plans And Indexes In Sql Server

Understanding Execution Plans And Indexes In Sql Server
Published 12/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Learn Step By Step Explanation of Indexes and Execution Plans using T-SQL Commands in Microsoft SQL Server

What you’ll learn

Requirements

RDBMS concepts should be known & should have good hands-on on T-SQL Commands

SQL Server 2022 (lower version can work also) and SQL Server Management Studio should be installed already

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Page in SQL Server

Lecture 3 Extent in SQL Server

Lecture 4 Heap in SQL Server

Lecture 5 Clustered Index

Lecture 6 Non Clustered Index

Lecture 7 Heap with Non Clustered Index

Lecture 8 Indexes are not very Deep

Lecture 11 Index Fragmentation

Lecture 12 More on Fragmentation

Lecture 13 Index Creation using T-SQL Commands

Lecture 14 Index Rebuild and ReOrganize

Lecture 15 Index Fragmentation Practical

Lecture 16 FillFactor

Lecture 17 T-SQL Command to introduce FillFactor in an Index

Lecture 18 Included Columns

Lecture 19 Data Type on Clustered Index

Section 2: Execution Plans

Lecture 20 What are Estimated & Actual Execution Plans along with Statistics

Lecture 21 Download and Restore AdventureWorks Database
Lecture 22 Table Scan Operator

Lecture 23 Index Scan Operator

Lecture 24 Index Seek Operator

Lecture 25 Key Lookup, RowID Lookup & Nested Loop Operators

Lecture 26 Index supports Wild Card

Lecture 27 Sort in Execution Plan

Lecture 28 Merge Join Operator

Lecture 29 Hash Join,Merge Join & Nested Loop Operators

Lecture 30 Compute Scalar Operator

Lecture 31 Stream and Hash Aggregate Operators

Lecture 32 Subtree Cost of Stream and Hash Aggregate

Lecture 33 Semi Joins & Anti Semi Joins in Execution Plan

Lecture 34 Merge using Left Anti Semi Join in Execution Plan

Lecture 35 Execution Plan of Insert Operation

Lecture 36 Passthrough property in Nested Loop

Lecture 37 Execution Plan of Delete Operation

Lecture 38 Parallelism in Execution Plan

Lecture 40 Segment Operator & Sequence Project Operators in Execution Plan

Lecture 41 Lazy Spool in Execution Plan

Lecture 42 Eager Spool and Halloween Problem Practical

Section 3: Patterns to Notice in Execution Plans

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

Lecture 44 Parameter Sniffing vs Parameter Sensitive Plan Optimization Practical

Lecture 45 Merge Join Patterns

Lecture 46 Hash Join Patterns

Lecture 47 Key Lookup Patterns

Lecture 48 Sort Aggregate & Parallelism Patterns

Lecture 49 Warnings in Execution Plan