Course Introduction
Query Optimization
Sargability
Indexing Strategies
-
Index Overview
-
Different Types of Indexes in SQL Server (11:37)
-
Clustered vs Non-Clustered Indexes
-
Indexes Explained (10:35)
-
Index Design Best Practices (1:27)
-
Statistics Maintenance
-
Index Maintenance
-
Dangers of Maintenance Plan Wizards
-
Index Scan versus Seek
-
Covering Indexes
-
Removing Indexes - Danger (2:03)
Smells
Database Design Considerations
Performance Monitoring
Analyzing Wait Statistics
Isolation Levels
Performance Tuning Techniques
Deadlocking and Blocking
-
What is a Deadlock (2:42)
-
What is Blocking (1:00)
-
Why Blocking Happens (2:44)
-
Blocking Demo (3:48)
-
Deadlock Demo (3:06)
-
Differences Between Deadlocks and Blocking (1:53)
-
How to Find Blocking (3:49)
-
How to Fix Deadlocks (2:26)
-
How to See Deadlocks In Database Health Monitor (3:06)
-
Prevention and Monitoring (3:06)
-
Why Does Seeing Blocking and Deadlocks Matter (1:17)
Missing Index Recommendations
Benchmarking and Baselines
Managing Databases and Files
Server Settings
Sharding for Large Systems
Review - Wrap Up
