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,627 reads

Blogs

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 30 Nov 2020

By

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

Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes

By

A project I’ve been meaning to work on for a while has been to...

Read the latest Blogs

Forums

Operand type clash: text is incompatible with datetime2

By AMCiti

Dear Group: I am not sure what is causing this, and having a terrible...

Can I clone a database across servers?

By SQL Guy 1

Hi all, I have a database that resides on server A and I need...

Costing per database

By TJ_T

Hi, I am just checking to see if anyone has ever did a costing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The TUF File

See possible answers