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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy