Internals of indexing in SQL Server: All you need to know!!!
In this video, I am going to talk about the importance of the index in SQL Server with specific examples.
Furthermore, I will thoroughly explain about clustered and non-clustered indexes. I will also explain about covering and include indexes.
Chapters:
0:00 - Introduction
0:32 - High level overview of the index
1:48 - Importance of the indexing
7:45 - Internals of the SQL Server storage system (brief)
9:20 - Non-clustered indexes
15:11 - Non-clustered index non-working cases
21:00 - Clustered indexes
26:23 - Automatic creation of indexes
26:57 - Clustered + non-clustered index cases
28:57 - Covering indexes
31:14 - Include indexes
📚 ►SQL Server internals: • SQL Internals
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Gro...
🚀 ► Full course on Troubleshooting sessions: • Troubleshooting
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP