Post reply

Generate Create All Secondary Indexes For Entire Database

  • July 7, 2008 at 3:18 pm

    #209656

    Comments posted to this topic are about the item Generate Create All Secondary Indexes For Entire Database

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

  • August 25, 2008 at 5:00 am

    #862453

    xx

  • August 25, 2008 at 5:41 am

    #862463

    I think this is some nice code. However, my cut/paste experience lead to many format problems. I had a bunch of ? marks after pasting this code into text pad. I think the formatting caused some of these problems. I was able to fix this by doing a find and replace operation.

    Thanks Again. Good ideas.

    [font="Tahoma"]Cheers,

    Sean :-D[/font]

  • April 10, 2009 at 4:37 pm

    #975987

    Andrew-

    This does not add indexes to all columns. Where did you get that idea?? What were you reading? There is no blindly adding here!!!!

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

  • September 23, 2011 at 6:34 am

    #1385659

    Sean, the ?'s appear during copy/paste operations for some code. The easiest solution is the perform a Find/Replace on the ?'s and replace them with spaces. If you editor supports it, you can take 4 ?'s and replace them with a tab.

  • September 23, 2011 at 12:59 pm

    #1386002

    I really like it. With a little tweaking, I'm sure it could be coded to detect an existing filegroup on any of the indexes and insert them automatically in the output code. I work with several databases that have only some indexes in a file group, and others not.

    Thanks for sharing,

    --Richard

    -- RTW
    Be curious!

  • May 12, 2016 at 7:08 am

    #1878566

    Thanks for the script.

Viewing 7 posts - 1 through 6 (of 6 total)

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