Home > Administration > Index_Name Function for SQL Server

Index_Name Function for SQL Server

We have the database_name, object_name, object_schema_name but don’t have index_name.  So when accessing information in sys.dm_db_index_usage stats, it becomes troublesome to find out index name for al indexes.

Starting SQL 2008+ they updated the object_name function.  Before it used to be object_name(object_id) in context of current database; however the new function is object_name(object_id,[database_id]).  If they can do that for object_name & schema_name, why not indexes?

Searching Microsoft Connect, found the recommendation for it (link). Microsoft closed the feedback saying its too late for 2008, it will be looked at next version.  Well 2012 is out, I still don’t see it.  But I was thinking we we can still vote on it “maybe” it will get more attention?

  1. July 31, 2014 at 10:43 am

    It’s very effortless to find out any topic on net as compared to books, as I found
    this post at this site.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: