1 -Section Overview
2 -Heap
3 -Index Basics
4 -Nonclustered Index
5 -Nonclustered Index Types And Use Cases
6 -Clustered Index - Introduction
7 -Clustered Index Design
8 -Clustered Index On An Integer Column
9 -Clustered Index On A GUID Column
10 -Clustered Index Type And A Table Size
11 -(Script 002 #1) - Clustered Index Key Size Impact
12 -(Script 002 #2) - IDENTITY Gaps
13 -Nonclustered Primary Keys
14 -Data Access Operators
15 -Query Patterns
16 -(Script 002 #3) - Indexes And Cardinality
17 -(Script 002 #4) - Composite Index
18 -(Script 002 #5) - Composite Index vs Index With Included Column
19 -(Script 002 #6) - Non-sargable queries
20 -Nested Loops
21 -Merge Join
22 -Hash Join
23 -(Script 002 #7) - Indexing For JOIN
24 -(Script 002 #8) - Indexing For ORDER BY
25 -(Script 002 #9) - Indexing For GROUP BY
26 -(Script 002 #10) - Indexing For COUNT
27 -(Script 002 #11) - Indexing For MIN, MAX, SUM, AVG
28 -(Script 002 #12) - Analyzing indexes with DMVs
