• Repost - originally posted 22-05-2012

sp_helpindex stored procedure improvements


When SQL Server introduced the concept of included columns in indexes in SQL Server 2005, they didn't really provide any way to get information on the included columns on an index. Kimberly L Tripp created help index 2 to enhance help index. Since then there have been a number of further changes to this stored procedure and even a help index 3.

Download the one that suits you best and add it to your toolkit.

I would also book mark SQL Skills as an excellent resource

https://www.sqlskills.com/


Recent Posts

See All

Migrating SSIS packages to AWS

We are currently migrating a large amount of SSIS packages (SQL Server 2008R2) to SQL Server 2016 at AWS. It has been a learning exercise to get these packages running. What we have learnt (so far) is