2

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

Charles
  • 50,943
  • 13
  • 104
  • 142
usr
  • 168,620
  • 35
  • 240
  • 369
  • 3
    Although the ITW is a great tool for identifying inefficiencies in your database, applying the recommendations blindly 100 at a time without understanding the consequences of each IMO isn't going to solve things. Take the time to understand and design clustering, NC indexes and statistics around your data, taking into consideration reads, writes, index widths etc. Silver bullets are dangerous. – StuartLC Jun 02 '12 at 19:23
  • You are right. I intend to go through all recommendations. I don't apply them blindly. However, the standard for a recommendation applying is very low as the work load is read-only and the database size small. – usr Jun 02 '12 at 19:29

0 Answers0