Project Description
The DTA Output Renamer takes recommendations from the SQL Server Database Tuning Advisor (DTA) and updates the names of the indexes/statistics to be more human readable based on the object definition (i.e., column names instead of IDs).

This application doesn't handle everything that can be generated by the DTA, but does cover Clustered/Non-Clustered Indexes (with and without INCLUDE columns) and Statistics. It should be easy to extend it if you need to. This app is just something I whipped up in an hour or two, so it isn’t the most robust thing ever created.

Large indexes will sometimes go past the 128 character limit... you'll need to modify them by hand to meet your naming convention for this case.

Last edited May 19, 2009 at 5:20 AM by ddarden42, version 3