OneScript Team Blog

A world of automation script samples based on IT Pros' real-world tasks

[Script Of July 11] How to list tables with index issues in a SQL database

[Script Of July 11] How to list tables with index issues in a SQL database

  • Comments 1
  • Likes
image image
July
11
image

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/scriptcenter/How-to-easily-run-an-0c0eb47a/.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

This script will demonstrate how to list tables with the following index issues in a database:

  • Tables with no index
  • Tables with no clustered index but with non-clustered index
  • Tables with more indexes than columns

We provide this script for people to reference. If you want to know tables with no index or clustered index, or tables with more indexes than columns, this script will provide some help.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment