List all indexes with keys, description and size

This script combines functionality of sp_helpindex and sp_spaceused to list all tables with individual indexes, their keys and description  (sp_spaceused cannot do that) and size in MB per individual index (sp_helpindex cannot do that either). Feel free to use and modify as you see fit. Hope it can help.

5 (9)

2007-07-03 (first published: )

2,629 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Read the latest Blogs

Forums

What counts for a DBA: Foresight

By Louis Davidson (@drsql)

Comments posted to this topic are about the item What counts for a DBA:...

SSRS report server installation

By sqlfriend

If we want to install SQL server SSRS service on another server separating  it...

prevent certain characters being inserted into table

By Siten0308

Hello, So i am assigned a task, that if a user inserts a certain...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers