• 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/


14 views0 comments

Recent Posts

See All

Standardise database sizes and automation

The default setting for the initial sizing of data and log files (and their autogrowth) is not adequate. I like to make sure that we set standard sizes for our data and log files - plus standard sizes

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

Autoclose and autoshrink - set them to off

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose and/or autoshrink. If so, you should change these settings as p