Database Tuning Advisor: Naming of Recommended Indexes and Statistics

437 views Asked by At

When using the SQL Server Database Tuning Advisor, it generates default names for the objects (indexes, statistics and views) it recommends. Here are a few:

enter image description here

These names are horrible.

Is there an efficient method to assign reasonable names to all those objects? I'd like to apply about 100 recommendations at once, and I don't feel like manually typing a name for each of them.

Here is an example of a "nice" name: IX_StudyCourses_Name

0

There are 0 answers