sp_helpindex2

Retrieve included columns info as well along with other column list

Mid September Free Training from PASS

There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!

Disabling Indexes

Index Types

Help Index

Get all index details from all databases on an instance

Index Structures

Efficient SQL Server Indexing by Design

Having a good set of indexes on your SQL Server database is critical to performance. Efficient indexes don't happen by accident; they are designed to be efficient. Greg Larsen discusses whether primary keys should be clustered, when to use filtered indexes and what to consider when using the Fill Factor.

Clustered indexes

Proactive Database Index Creation

Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.

SQL Server Column Considerations and Column Placement

Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.