In SQL Server, indexes are one of the most important data structures—they are the only means by which SQL Server can process huge tables in a reasonable amount of time. In my November column, "Get Into Index Structures" (InstantDoc ID 43939), I described the structure and organization of SQL Server indexes and showed you an undocumented stored procedure that you can use to find the size of an index. SQL Server offers very few documented tools for examining internal information (such as metadata) about indexes, but it does have some. I show you some of the lesser known tools and techniques this month.