move table that has no index from one Filegroup to another

Is there a better way to move a huge table that has no index on it from one
Filegroup to another ? Using SQL 2000The best way is to create a clustered index. Otherwise, you have to create a
new table, copy all of the data, drop the old table, rename the new one, and
I did not even mention any referential integrity issues.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#MS1ZX#VDHA.2168@.TK2MSFTNGP09.phx.gbl...
> Is there a better way to move a huge table that has no index on it from
one
> Filegroup to another ? Using SQL 2000
>|||And what if you had a clustered index created that had references to it ?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:uxzo5T$VDHA.2360@.TK2MSFTNGP12.phx.gbl...
> The best way is to create a clustered index. Otherwise, you have to create
a
> new table, copy all of the data, drop the old table, rename the new one,
and
> I did not even mention any referential integrity issues.
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:#MS1ZX#VDHA.2168@.TK2MSFTNGP09.phx.gbl...
> > Is there a better way to move a huge table that has no index on it from
> one
> > Filegroup to another ? Using SQL 2000
> >
> >
>|||Well, the table is avaiable for reading, but not for writing during the
index rebuild, thus the RI is maintained.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u#At6p$VDHA.1280@.tk2msftngp13.phx.gbl...
> And what if you had a clustered index created that had references to it ?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:uxzo5T$VDHA.2360@.TK2MSFTNGP12.phx.gbl...
> > The best way is to create a clustered index. Otherwise, you have to
create
> a
> > new table, copy all of the data, drop the old table, rename the new one,
> and
> > I did not even mention any referential integrity issues.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > FAQ from Neil & others at: http://www.sqlserverfaq.com
> > Please reply only to the newsgroups.
> > PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:#MS1ZX#VDHA.2168@.TK2MSFTNGP09.phx.gbl...
> > > Is there a better way to move a huge table that has no index on it
from
> > one
> > > Filegroup to another ? Using SQL 2000
> > >
> > >
> >
> >
>