Script for no of Index in a table

Question

Post reply

Script for no of Index in a table

thava

SSCrazy

Points: 2275
More actions
November 23, 2012 at 12:35 am

#265149

Comments posted to this topic are about the item Script for no of Index in a table
Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Charles Kincaid SSChampion Points: 13593 More actions · Answer 1

Great script. Thanks.

I added:

ORDER BY HeapIndex DESC, t.name

In that way the ones that I need to work on are at the top of the list. It's not so important if you have a few tables. My current application has nearly 200 and this makes things eaier to spot.

Great work.

ATBCharles Kincaid

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

I love this. I added an ORDER BY and ordered it a couple different ways. When I ran it for see which tables had the most TotalNoofIndex value, I was blown away that three of my tables had over 20, one had 27.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

I'll be sharing this with fellow IT workers today.

thava SSCrazy Points: 2275 More actions · Answer 4

with pleasure

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]