SQL Server Indexes. This presentation covers the following topics :
- Internal fragmentation
- External Fragmentation
- Identify Fragmentation
- Numeric Index Data
- Date Index Data
- Character Index Data
- GUID Index Data
- Computed Column and Indexes
- Single Column vs. Composite Indexes
- Ascending vs. Descending Indexes
- Forwarding Points
- Create Clustered Indexes
- Drop Clustered Indexes
- Altering a Clustered Index
- Fill Factor
- Heap Table Vs. Clustered Index In Depth
For more presentations regarding this subject, use this link.