tag:blogger.com,1999:blog-6664701585971860985.post4810166182905475701..comments2023-06-28T16:58:07.380+01:00Comments on SQL Server 365: Unused IndexesAnonymoushttp://www.blogger.com/profile/16118372390680186915noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6664701585971860985.post-89054380777987301172013-04-17T22:02:47.056+01:002013-04-17T22:02:47.056+01:00I've updated this script to exclude unused uni...I've updated this script to exclude unused unique indexes and also improved the drop script so that it includes the USE DatabaseName; for each index making it not only re-runable but instantly usable without having to manually change or add the database context for each database.Anonymoushttps://www.blogger.com/profile/16118372390680186915noreply@blogger.comtag:blogger.com,1999:blog-6664701585971860985.post-24525188919081016902013-02-21T11:08:11.126+00:002013-02-21T11:08:11.126+00:00Glad you like it Andy! Check out the tables witho...Glad you like it Andy! Check out the tables without a Clustered Index and Tables Without a Primary Key posts. They might give you equally as much value :)Anonymoushttps://www.blogger.com/profile/16118372390680186915noreply@blogger.comtag:blogger.com,1999:blog-6664701585971860985.post-38769204388931514822013-02-21T11:04:54.107+00:002013-02-21T11:04:54.107+00:00This is handy, ive added it as a metric to red gat...This is handy, ive added it as a metric to red gate monitor. They do have a custom metric on the site but it includes all indexes primary keys etc.Anonymoushttps://www.blogger.com/profile/06993221695130976315noreply@blogger.com