THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Updated sp_indexinfo

It was time to give sp_indexinfo some love. The procedure is meant to be the "ultimate" index information procedure, providing lots of information about all indexes in a database or all indexes for a certain table. Here is what I did in this update:

  • Changed the second query that retrieves missing index information so it generates the index name (based on schema name, table name and column named - limited to 128 characters).
  • Re-arranged and shortened column names to make output more compact and more commonly used column moved to the right.
  • Uncommented some columns that were previously commented. (At least one, filter, has to be commented if you want to run this on 2005.)
  • Added support for columnstore indexes.
  • Decoded the type for columnstore indexes to col-store.

You find the procedure here. 

Published Thursday, May 22, 2014 8:09 PM by TiborKaraszi
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Jon Morisi said:


May 22, 2014 5:57 PM

JH said:

Your procedure does not work.  It doesn't return any rows.

May 28, 2014 12:56 PM

TiborKaraszi said:

How do you call it? Note that you are only to provide table name (if any), not schema name. Like:

EXEC 'Products'


EXEC 'Production.Products'

May 28, 2014 12:58 PM

randy hartwig said:

Hi, is your link down?  I just saw this and would like to try your procedure but I keep getting 'no access'.

December 9, 2014 11:09 AM

TiborKaraszi said:

Hi Randy,

The link works for me. Perhaps you can find a cached page at Google?

December 9, 2014 1:06 PM

Leave a Comment


This Blog


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement