Reply to Re: move indexes via ALTER INDEX

Your name:

Reply:


Posted by Paul S. Randal [MS] on 03/13/07 06:32

Check out the CREATE INDEX ... WITH DROP_EXISTING syntax where you specify
the filegroup to create the new index on.

--
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx


"rcamarda" <robert.a.camarda@gmail.com> wrote in message
news:1173752583.908449.87100@30g2000cwc.googlegroups.com...
>I was checking out an indexes property via SQL 2005 Management Studio
> and it looks like I can move the index to other filegroups via the
> drop down.
> I checked the BOL ALTER INDEX and I didnt see an argument for this
> action. I see stuff about PARTITION, but I think that is for row
> partitioning??
> I want to move existing indexes from the PRIMARY filegroup to a new
> file group just for indexes, which is called INDEXES.
> Can this be done via ALTER INDEX or some other way?
> TIA
> Rob
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация