<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by michael vessey
»
move all indexes to a secondary file group
12 posts, Page 1 of 2
1
2
»»
move all indexes to a secondary file group
Rate Topic
Display Mode
Topic Options
Author
Message
MVDBA
MVDBA
Posted Saturday, September 29, 2007 9:25 PM
SSCrazy
Group: General Forum Members
Last Login: Monday, April 29, 2013 10:15 AM
Points: 2,261,
Visits: 758
Comments posted to this topic are about the item
move all indexes to a secondary file group
MVDBA
Post #404559
timothyawiseman
timothyawiseman
Posted Monday, August 18, 2008 5:43 PM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:01 PM
Points: 743,
Visits: 900
I really like the script, but it does not maintain the unique portion of indexes which makes it hard to use in some cases.
---
Timothy A Wiseman
SQL Blog:
http://timothyawiseman.wordpress.com/
Post #554679
keppro
keppro
Posted Saturday, August 30, 2008 5:15 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, May 26, 2009 11:16 PM
Points: 1,
Visits: 73
Thanks a lot to the author!
One problem with the script: it doesn't recognize indexes with included fields. Does anybody know what system table(s) contain this information? Better yet, is there any kind of API for Management Studio's scripting?
Post #561682
timothyawiseman
timothyawiseman
Posted Sunday, August 31, 2008 9:47 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:01 PM
Points: 743,
Visits: 900
keppro (8/30/2008)
Thanks a lot to the author!
One problem with the script: it doesn't recognize indexes with included fields. Does anybody know what system table(s) contain this information? Better yet, is there any kind of API for Management Studio's scripting?
It is in sys.index_columns, with the included columns marked by a 1 in the is_included column.
---
Timothy A Wiseman
SQL Blog:
http://timothyawiseman.wordpress.com/
Post #561773
hydbadrose
hydbadrose
Posted Friday, October 10, 2008 2:59 PM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:03 PM
Points: 213,
Visits: 834
I loved the script. I wish the author or some cold post the reverse process like moving non-clustered indexes from secondary to primary with clustered indexes.
Post #584257
SQL2005-982522
SQL2005-982522
Posted Wednesday, January 07, 2009 11:03 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, May 15, 2009 3:36 PM
Points: 1,
Visits: 5
Got an error about foreign key. Any idea?
Msg 3723, Level 16, State 6, Line 1
An explicit DROP INDEX is not allowed on index 'xxxxxxxxxxxxxx'. It is being used for FOREIGN KEY constraint enforcement.
Post #631692
repent_kog_is_near
repent_kog_is_near
Posted Monday, October 05, 2009 9:21 PM
SSC Veteran
Group: General Forum Members
Last Login: Monday, August 08, 2011 1:21 PM
Points: 264,
Visits: 331
What is the logic behind keeping Non-Clustered with Primary and Clustered with Secondary?
Post #798293
Ryan McCauley
Ryan McCauley
Posted Monday, February 08, 2010 10:44 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, January 25, 2013 10:27 AM
Points: 181,
Visits: 138
I've updated this script to do a few additional things, like
- Properly re-create unique indexes
- Handle Included columns
- Do "online" index moves w/error handling - creates new index, drops old, then renames
- Uses existing fill factor if the source index explicitly defines it
I've posted the script at my blog - I'm interested if anybody else has feedback or something they'd like to see added.
http://www.trycatchfinally.net/post/2010/02/08/Migrate-database-indexes-to-a-new-file-group.aspx
Ryan
Post #861882
AK1516
AK1516
Posted Wednesday, September 28, 2011 3:17 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, April 22, 2013 8:20 AM
Points: 118,
Visits: 754
is this link working ?????????
Post #1182878
Ryan McCauley
Ryan McCauley
Posted Wednesday, September 28, 2011 4:21 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, January 25, 2013 10:27 AM
Points: 181,
Visits: 138
I've fixed the redirection on my blog, so you can view it now. I must have changed the layout at some point and not set up this forwarding page properly.
Sorry for the confusion.
Ryan
Post #1182896
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
