SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Generate Create All Secondary Indexes For Entire Database


Generate Create All Secondary Indexes For Entire Database

Author
Message
Gary L. Fry-196295
Gary L. Fry-196295
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 221
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
Andrew Kelly
Andrew Kelly
SSC Veteran
SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)

Group: General Forum Members
Points: 256 Visits: 209
xx



Sean Woehrle
Sean Woehrle
SSC Veteran
SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)

Group: General Forum Members
Points: 247 Visits: 155
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.

Cheers,

Sean :-D

Gary L. Fry-196295
Gary L. Fry-196295
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 221
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
tskelley
tskelley
SSC Eights!
SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)SSC Eights! (906 reputation)

Group: General Forum Members
Points: 906 Visits: 1224
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.



The Learner
The Learner
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 245
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!
Iwas Bornready
Iwas Bornready
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38742 Visits: 886
Thanks for the script.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search