Comments
Sort by recent activity
Hey Brian,
to be honest, I am not sure, how these indexes got there, but they don't contain anything random and are all owned by the same schema. We turned off automatic index generation a long time ago, but it seems like some are still around. Could have been some old performance tool that made this poor name choice as well. Anyway - since this is in production I am not going to be able to get rid of those in the short term.
I did some digging and it turns out, Microsoft actually does allow multiple indexes with identical names, as long as they are not created on the same object:
index_name
Is the name of the index. Index names must be unique within a table or view but do not have to be unique within a database. Index names must follow the rules of identifiers.
See http://msdn.microsoft.com/en-us/library ... (v=sql.105).aspx
I am using Dependecy Tracker Version 2.8.1.164, which I downloaded just yesterday as part of the SQL Developer Bundle.
-- Florian / comments
Hey Brian,
to be honest, I am not sure, how these indexes got there, but they don't contain anything random and are all owned by the same schema. We turned off automatic index generation a long tim...