Instance wide missing index

Total article views: 520 | Views in the last 30 days: 18

This script is used to find tables without primary key, clustered index and no index in an instance.

Copy the script and paste into query analyer. The output will be DatabaseName, TableName and Missing Index.

Total article views: 520 | Views in the last 30 days: 18

Your response

Related tags

By Vampire | Category: Database Maintenance

(not yet rated) | 24 reads

By Jesse Reich | Category: Database Maintenance

(not yet rated) | 2,490 reads

Like this? Try these...

By BarryK | Category: Fragmentation

| 996 reads

By Wilfred van Dijk | Category: Administration

(not yet rated) | 597 reads

By John Liu | Category: Locking

| 1,057 reads

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Email: Password: Remember me: Forgotten your password?

Email: Password:

Confirm:

Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com