Technical Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(9)

You rated this post out of 5. Change rating

2007-07-03 (first published: )

2,675 reads

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

By

In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...

Car Update October 2026

By

This month I want to look at a few of the things I’ve seen...

Read the latest Blogs

Forums

PostgreSQL 19 Is Late

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PostgreSQL 19 Is Late

Hyperscale Replicas V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas V

A Heavy Heart

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Heavy Heart

Visit the forum

Question of the Day

Hyperscale Replicas V

I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?

See possible answers