THE SQL Server Blog Spot on the Web

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

Tibor Karaszi

Yet some more fixes for sp_indexinfo...

I got some more feedback (see yesterday's blog post on this) which I now incorporated into sp_indexinfo. See change log at bottom of the article for details.

Published Wednesday, July 9, 2008 11:03 AM 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



Jim said:

Could you do a short article on interpreting the results of sp_indexinfo?

July 14, 2008 10:26 AM

TiborKaraszi said:

Done (adding some documentation). It took a while... :-)

February 18, 2009 12:28 PM

Henrik Staun Poulsen said:

May I suggest that you put a coalesce around the Included_columns column?

and change



, CASE WHEN i.is_disabled = 1 THEN 'disabled' ELSE p.location  END AS Location

Best regards,

Henrik Staun Poulsen

February 2, 2010 2:45 AM

TiborKaraszi said:

Tack Henrik. I did the change for disabled/location. Good catch.

I did not get the point about coalesce and inclued columns, though. There already is such, has been for a while. Perhaps you have an oder version of the proc? Check out the current version and let me know if I misunderstand.

February 4, 2010 1:58 PM

Leave a Comment


This Blog


Privacy Statement