Activity overview
Latest activity by florian kistner
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...
Exception on multiple indexes with identical name
Hello,
I am having trouble with identically named indexes in some of my databases on SQL Server 2008 R2.
It looks like the Dependency Tracker assumes that index names are globally unique, but this ...