THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Downloads   Opml View as RSS news feed in XML

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


Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
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

 

Jason Haley said:

July 9, 2008 10:34 AM
 

Log Buffer #105, a Carnival of the Vanities for DBAs said:

PingBack from http://www.pythian.com/blogs/1115/log-buffer-105-a-carnival-of-the-vanities-for-dbas

July 11, 2008 12:06 PM
 

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) 
(optional)
(required) 
Submit

This Blog

Syndication
©2006-2009 SQLblog.comTM
Brought to you by Peter DeBetta & Adam Machanic
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement