data-konzept

'Since I’ve rewritten sp_helpindex a few times, I have a few blogs posts in this category. Each time I do an update I’ll make the NEW version titled USE THIS and I’ll change all others to (OLD).

The point of this updated version of sp_helpindex is to add details for newer functionality (included columns and filters) as well as better describe what’s REALLY in your indexes (at the leaf level AND up the b-tree). You use my version of sp_helpindex in exactly the same way as sp_helpindex; if you can pass it into sp_helpindex then you can pass it into sp_SQLskills_helpindex!

EXAMPLES:

sp_helpindex tablename WORKS

sp_helpindex owner.tablename DOES NOT WORK

sp_helpindex 'owner.tablename' WORKS

To setup this version of sp_helpindex, you need TWO scripts. Both scripts are generic and work on all versions from SQL Server 2005 through SQL Server 2016. To produce the detailed output, you need to first create these system procedures.'...

https://www.sqlskills.com/blogs/kimberly/sp_helpindex-v20170228/