Updated sp_indexinfo

Posted by TiborKaraszi on SQL Blog See other posts from SQL Blog or by TiborKaraszi
Published on Thu, 22 May 2014 17:09:00 GMT Indexed on 2014/05/26 21:53 UTC
Read the original article Hit count: 251

Filed under:
|
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...(read more)

© SQL Blog or respective owner

Related posts about indexes

Related posts about Performance