THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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.

http://www.karaszi.com/SQLServer/util_sp_indexinfo.asp

Published Wednesday, July 09, 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

Comments

 

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

  p.location  

to

, 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

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