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

Tibor Karaszi

Sp_indexinfo updated

For a long while, I've had a few things I wanted to add for sp_indexinfo (my procedure which returns bunch of information for indexes).

Dejan Sarka suggested adding XML indexes as well as making the column list look nicer. I've also had a request to add some documentation of what the procedure returns. Done. :-)

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

Published Wednesday, February 18, 2009 7:30 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

Comments

 

Lidong said:

Hi Tibor,

do you want to add the filter definition to this sp?

Thanks!

February 19, 2009 1:28 AM
 

TiborKaraszi said:

Hmm, not sure what you mean by filer definition...

Do you mean as in filtered indexes? Hmm, that would mean two versions, one for 2005 and another for 2008. The addition is simple enough to do if you wish....

OK, here's what I do. I'll add it in there, but comment that line. So we still have only one version and if you wish to have this and you create the proc on 2008, you can just uncomment that line. The proc is up there in some 20 minutes. :-) Thanks for the tip!

February 19, 2009 2:46 AM
 

jamiet said:

Hi Tibor,

Don't s'pose you'd like to add that to SQL Mesh (http://tinyurl.com/sqlmesh) by any chance would you?

-Jamie

February 20, 2009 6:24 AM
 

JackMcC said:

Hi Tibor,

Great script however I found a tiny bug - if you have LOB data in a table the row for the Clustered will return double the actual row count. When you query sys.allocation_units it will produce a sum for IN_ROW_DATA and LOB_DATA resulting doubling the row count for the table.

Cheers,

Jack.

October 21, 2010 4:21 AM
 

TiborKaraszi said:

Ahh, yes. Thanks Jack. I did a similar mistake with sp_tableinfo. I will look at it and fix, but I'm swamped at the moment. Will take a week or two... :-)

October 23, 2010 6:11 AM
 

TiborKaraszi said:

@JackMcC: Bug now fixed. Thanks again!

November 9, 2010 3:26 AM
 

Tibor Karaszi said:

JackMcC reported correctly at http://sqlblog.com/blogs/tibor_karaszi/archive/2009/02/18/sp-indexinfo-updated.aspx

November 9, 2010 3:29 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

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