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

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Top Azure Synapse Analytics and Power BI questions

By

I have listed below the top questions I see from customers about Azure Synapse...

Pre-Conference Workshop and Sessions at PASS Summit

By

I’m pleased to announce that I will be presenting at PASS Summit. This year...

Read the latest Blogs

Forums

why cannot use ClientProcessID to trace data in SQL Server Profile.

By 892717952

A C/S system is running on a SQL Server database, and I get its...

Copying an Azure SQL Database with PowerShell

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Copying an Azure SQL Database...

Does T-SQL have a way of truncating real and float values?

By Rod at work

I'm working on a new app and database, which has real data types in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers