Script for no of Index in a table

  • 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]

  • 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

  • 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.

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

  • 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