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.