Index stats with key,included columns, size - all you can eat

Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition

Shortening a column

Included Indexes

Index Scan: Ordered or not?

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem

Get user table indexes, size and column order

get user table indexes, size and column order

The Importance of Database Indexing

In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.

Columnstore Indexes

Index Fragmentation

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.