SQL Server Indexes

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.

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…