November 23, 2012 at 12:35 am
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]
November 26, 2012 at 11:04 am
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
May 5, 2016 at 7:22 am
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.
May 5, 2016 at 7:24 am
I'll be sharing this with fellow IT workers today.
May 22, 2016 at 8:06 am
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]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply