Generate Create All Secondary Indexes For Entire Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gary Fry » Generate Create All Secondary Indexes For...

Generate Create All Secondary Indexes For Entire Database

Rate Topic

Display Mode

Topic Options

Author

Message

Gary L. Fry-196295

Posted Monday, July 07, 2008 3:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 27, 2011 12:09 PM
Points: 6, 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

Post #529663

Andrew Kelly

Posted Monday, August 25, 2008 5:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:51 PM
Points: 184, Visits: 114

Why would you even think up the need for a script like this? Would you really blindly add indexes to every column on every table?

Post #558052

Sean Woehrle

Posted Monday, August 25, 2008 5:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 04, 2013 6:42 AM
Points: 7, Visits: 76

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.

Post #558067

Gary L. Fry-196295

Posted Friday, April 10, 2009 4:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 27, 2011 12:09 PM
Points: 6, 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

Post #695100

tskelley

Posted Friday, September 23, 2011 6:34 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 6:03 AM
Points: 33, Visits: 759

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.

Post #1180014

The Learner

Posted Friday, September 23, 2011 12:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:24 PM
Points: 6, Visits: 183

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!

Post #1180387

« Prev Topic | Next Topic »

Permissions