An Introduction to SQL Server Indexes: Stairway to SQL Server Indexes Level 1

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key

Understanding Indexes

This article contains an introduction to SQL Server indexes and how they are used in your queries.

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude

Indexing Lookups

Query to get tables with no clustered indexes

Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)

Effective Clustered Indexes

As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.

SQL Server Index Tuning for Mere Mortals

One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...

Can You Dig It? – Missing Indexes

She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...

The FILL FACTOR

Will the FILLFACTOR Index option help to boost my database performance?

Unique constraint on a nullable column