moving a table to another filegroup in T-SQL

Hi
I want to move a table to another filegroup using T-SQL (alter table ...).
In BOL i do not find an example of this case. I trried something like
alter <table>
move to <filegroup>
but it does not work
Can somebody help me please. Thanks Waldo
If your answer to Tibors post is Yes then,
Easiest method is to re-create the clustered index in new file group. This
will move the table to the new file group automatically.
This means data will be moved to new file group once you move the clustered
Index
If the table already has a clustered index, you can use the CREATE INDEX
command's WITH DROP_EXISTING clause to recreate
the clustered index and move it to a particular filegroup. When a table has
a clustered index, the leaf level of the index and the data pages of the
table essentially become one and the same. The table must exist where the
clustered index exists, so if you create or recreate a clustered
index-placing the index on a particular filegroup-you're moving the table to
the new filegroup as well.
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uROKsdrRHHA.2252@.TK2MSFTNGP02.phx.gbl...
> Does the table currently have a clustered index?
> Do you want the table to have a clustered index after you have moved it?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Waldo" <Waldo@.discussions.microsoft.com> wrote in message
> news:76EDDDC2-171D-42DA-843F-11B4D058BEF7@.microsoft.com...
>

moving a table to another filegroup in T-SQL

Hi
I want to move a table to another filegroup using T-SQL (alter table ...).
In BOL i do not find an example of this case. I trried something like
alter <table>
move to <filegroup>
but it does not work
Can somebody help me please. Thanks WaldoDoes the table currently have a clustered index?
Do you want the table to have a clustered index after you have moved it?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Waldo" <Waldo@.discussions.microsoft.com> wrote in message
news:76EDDDC2-171D-42DA-843F-11B4D058BEF7@.microsoft.com...
> Hi
> I want to move a table to another filegroup using T-SQL (alter table ...).
> In BOL i do not find an example of this case. I trried something like
> alter <table>
> move to <filegroup>
> but it does not work
> Can somebody help me please. Thanks Waldo|||If your answer to Tibors post is Yes then,
Easiest method is to re-create the clustered index in new file group. This
will move the table to the new file group automatically.
This means data will be moved to new file group once you move the clustered
Index
If the table already has a clustered index, you can use the CREATE INDEX
command's WITH DROP_EXISTING clause to recreate
the clustered index and move it to a particular filegroup. When a table has
a clustered index, the leaf level of the index and the data pages of the
table essentially become one and the same. The table must exist where the
clustered index exists, so if you create or recreate a clustered
index-placing the index on a particular filegroup-you're moving the table to
the new filegroup as well.
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uROKsdrRHHA.2252@.TK2MSFTNGP02.phx.gbl...
> Does the table currently have a clustered index?
> Do you want the table to have a clustered index after you have moved it?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Waldo" <Waldo@.discussions.microsoft.com> wrote in message
> news:76EDDDC2-171D-42DA-843F-11B4D058BEF7@.microsoft.com...
>

moving a table to another filegroup in T-SQL

Hi
I want to move a table to another filegroup using T-SQL (alter table ...).
In BOL i do not find an example of this case. I trried something like
alter <table>
move to <filegroup>
but it does not work
Can somebody help me please. Thanks WaldoDoes the table currently have a clustered index?
Do you want the table to have a clustered index after you have moved it?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Waldo" <Waldo@.discussions.microsoft.com> wrote in message
news:76EDDDC2-171D-42DA-843F-11B4D058BEF7@.microsoft.com...
> Hi
> I want to move a table to another filegroup using T-SQL (alter table ...).
> In BOL i do not find an example of this case. I trried something like
> alter <table>
> move to <filegroup>
> but it does not work
> Can somebody help me please. Thanks Waldo|||If your answer to Tibors post is Yes then,
Easiest method is to re-create the clustered index in new file group. This
will move the table to the new file group automatically.
This means data will be moved to new file group once you move the clustered
Index
If the table already has a clustered index, you can use the CREATE INDEX
command's WITH DROP_EXISTING clause to recreate
the clustered index and move it to a particular filegroup. When a table has
a clustered index, the leaf level of the index and the data pages of the
table essentially become one and the same. The table must exist where the
clustered index exists, so if you create or recreate a clustered
index-placing the index on a particular filegroup-you're moving the table to
the new filegroup as well.
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uROKsdrRHHA.2252@.TK2MSFTNGP02.phx.gbl...
> Does the table currently have a clustered index?
> Do you want the table to have a clustered index after you have moved it?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Waldo" <Waldo@.discussions.microsoft.com> wrote in message
> news:76EDDDC2-171D-42DA-843F-11B4D058BEF7@.microsoft.com...
>> Hi
>> I want to move a table to another filegroup using T-SQL (alter table
>> ...).
>> In BOL i do not find an example of this case. I trried something like
>> alter <table>
>> move to <filegroup>
>> but it does not work
>> Can somebody help me please. Thanks Waldo
>sql

Move Tables From Local to Hosting Provider's Server

I know about BOL. Please take a moment to refer me to any tutorials that may
help me to learn the basics as well as the finer points of moving tables and
other assets to the hosting provider's server.
<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/
Due to the limitations for access to the providers SQl Servers I use QALite
to script data from my tables and connect to the remote database via QA and
execute the scripts, thats the best way for me.
HTH, Jens Smeyer.
"clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>I know about BOL. Please take a moment to refer me to any tutorials that
>may help me to learn the basics as well as the finer points of moving
>tables and other assets to the hosting provider's server.
> <%= Clinton Gallagher
> METROmilwaukee (sm) "A Regional Information Service"
> NET csgallagher AT metromilwaukee.com
> URL http://metromilwaukee.com/
> URL http://clintongallagher.metromilwaukee.com/
>
|||Thanks for your comments Jens.
I can evaluate the same tool you are using but I can connect to my database
on the hosted site using Enterprise Manager or a tool with a web interface
the hosting provider makes available.
<%= Clinton Gallagher
"Jens Smeyer" <Jens@.remove_this_for_contacting_sqlserver2005.de> wrote in
message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
> Due to the limitations for access to the providers SQl Servers I use
> QALite to script data from my tables and connect to the remote database
> via QA and execute the scripts, thats the best way for me.
> HTH, Jens Smeyer.
>
> "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>
|||To be honest, to me these tools really suck. The WebTools provided by the
providers often don′t offer all the capabilities that I need, so I used to
rely on the standard tools like EM and QA, they are the best.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"clintonG" wrote:

> Thanks for your comments Jens.
> I can evaluate the same tool you are using but I can connect to my database
> on the hosted site using Enterprise Manager or a tool with a web interface
> the hosting provider makes available.
> <%= Clinton Gallagher
> "Jens Sü?meyer" <Jens@.remove_this_for_contacting_sqlserver2005.de> wrote in
> message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
>
>
|||Is this [1] what you're refrring to? Why would I not just use Enterprise
Manager?
I agree the tools with web interface can be less capable than desktop tools
but -- at the moment -- I don't even have a clue what tasks I need to
consider to move the tables to the hosting provider server. Its not like FTP
where I can just upload files I guess is it? :-( and its not like I don't
have the interest or the skills to learn but I need to learn what to do
before I decide what tools are best to do it that's why I've been asking for
referrals to tutorials.
<%= Clinton Gallagher
[1] http://www.rac4sql.net/qalite_main.asp
"Jens Smeyer" <Jens@.[Remove_that][for contacting me]sqlserver2005.de>
wrote in message news:E198A5D7-46A2-489C-BB03-E8E7ECF18625@.microsoft.com...[vbcol=seagreen]
> To be honest, to me these tools really suck. The WebTools provided by the
> providers often dont offer all the capabilities that I need, so I used to
> rely on the standard tools like EM and QA, they are the best.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "clintonG" wrote:

Move Tables From Local to Hosting Provider's Server

I know about BOL. Please take a moment to refer me to any tutorials that may
help me to learn the basics as well as the finer points of moving tables and
other assets to the hosting provider's server.
<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/Due to the limitations for access to the providers SQl Servers I use QALite
to script data from my tables and connect to the remote database via QA and
execute the scripts, thats the best way for me.
HTH, Jens Smeyer.
"clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>I know about BOL. Please take a moment to refer me to any tutorials that
>may help me to learn the basics as well as the finer points of moving
>tables and other assets to the hosting provider's server.
> <%= Clinton Gallagher
> METROmilwaukee (sm) "A Regional Information Service"
> NET csgallagher AT metromilwaukee.com
> URL http://metromilwaukee.com/
> URL http://clintongallagher.metromilwaukee.com/
>|||Thanks for your comments Jens.
I can evaluate the same tool you are using but I can connect to my database
on the hosted site using Enterprise Manager or a tool with a web interface
the hosting provider makes available.
<%= Clinton Gallagher
"Jens Smeyer" < Jens@.remove_this_for_contacting_sqlserve
r2005.de> wrote in
message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
> Due to the limitations for access to the providers SQl Servers I use
> QALite to script data from my tables and connect to the remote database
> via QA and execute the scripts, thats the best way for me.
> HTH, Jens Smeyer.
>
> "clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
> news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>|||To be honest, to me these tools really suck. The WebTools provided by the
providers often don′t offer all the capabilities that I need, so I used to
rely on the standard tools like EM and QA, they are the best.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"clintonG" wrote:

> Thanks for your comments Jens.
> I can evaluate the same tool you are using but I can connect to my databas
e
> on the hosted site using Enterprise Manager or a tool with a web interface
> the hosting provider makes available.
> <%= Clinton Gallagher
> "Jens Sü?meyer" < Jens@.remove_this_for_contacting_sqlserve
r2005.de> wrote
in
> message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
>
>|||Is this [1] what you're refrring to? Why would I not just use Enterprise
Manager?
I agree the tools with web interface can be less capable than desktop tools
but -- at the moment -- I don't even have a clue what tasks I need to
consider to move the tables to the hosting provider server. Its not like FTP
where I can just upload files I guess is it? :-( and its not like I don't
have the interest or the skills to learn but I need to learn what to do
before I decide what tools are best to do it that's why I've been asking for
referrals to tutorials.
<%= Clinton Gallagher
[1] http://www.rac4sql.net/qalite_main.asp
"Jens Smeyer" <Jens@.[Remove_that][for contacting me]sqlserver2005.
de>
wrote in message news:E198A5D7-46A2-489C-BB03-E8E7ECF18625@.microsoft.com...[vbcol=seagreen]
> To be honest, to me these tools really suck. The WebTools provided by the
> providers often dont offer all the capabilities that I need, so I used to
> rely on the standard tools like EM and QA, they are the best.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "clintonG" wrote:
>sql

Move Tables From Local to Hosting Provider's Server

I know about BOL. Please take a moment to refer me to any tutorials that may
help me to learn the basics as well as the finer points of moving tables and
other assets to the hosting provider's server.
<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/Due to the limitations for access to the providers SQl Servers I use QALite
to script data from my tables and connect to the remote database via QA and
execute the scripts, thats the best way for me.
HTH, Jens Süßmeyer.
"clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>I know about BOL. Please take a moment to refer me to any tutorials that
>may help me to learn the basics as well as the finer points of moving
>tables and other assets to the hosting provider's server.
> <%= Clinton Gallagher
> METROmilwaukee (sm) "A Regional Information Service"
> NET csgallagher AT metromilwaukee.com
> URL http://metromilwaukee.com/
> URL http://clintongallagher.metromilwaukee.com/
>|||Thanks for your comments Jens.
I can evaluate the same tool you are using but I can connect to my database
on the hosted site using Enterprise Manager or a tool with a web interface
the hosting provider makes available.
<%= Clinton Gallagher
"Jens Süßmeyer" <Jens@.remove_this_for_contacting_sqlserver2005.de> wrote in
message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
> Due to the limitations for access to the providers SQl Servers I use
> QALite to script data from my tables and connect to the remote database
> via QA and execute the scripts, thats the best way for me.
> HTH, Jens Süßmeyer.
>
> "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>>I know about BOL. Please take a moment to refer me to any tutorials that
>>may help me to learn the basics as well as the finer points of moving
>>tables and other assets to the hosting provider's server.
>> <%= Clinton Gallagher
>> METROmilwaukee (sm) "A Regional Information Service"
>> NET csgallagher AT metromilwaukee.com
>> URL http://metromilwaukee.com/
>> URL http://clintongallagher.metromilwaukee.com/
>>
>|||To be honest, to me these tools really suck. The WebTools provided by the
providers often don´t offer all the capabilities that I need, so I used to
rely on the standard tools like EM and QA, they are the best.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"clintonG" wrote:
> Thanks for your comments Jens.
> I can evaluate the same tool you are using but I can connect to my database
> on the hosted site using Enterprise Manager or a tool with a web interface
> the hosting provider makes available.
> <%= Clinton Gallagher
> "Jens Sü�meyer" <Jens@.remove_this_for_contacting_sqlserver2005.de> wrote in
> message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
> > Due to the limitations for access to the providers SQl Servers I use
> > QALite to script data from my tables and connect to the remote database
> > via QA and execute the scripts, thats the best way for me.
> >
> > HTH, Jens Sü�meyer.
> >
> >
> > "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> > news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
> >>I know about BOL. Please take a moment to refer me to any tutorials that
> >>may help me to learn the basics as well as the finer points of moving
> >>tables and other assets to the hosting provider's server.
> >>
> >> <%= Clinton Gallagher
> >> METROmilwaukee (sm) "A Regional Information Service"
> >> NET csgallagher AT metromilwaukee.com
> >> URL http://metromilwaukee.com/
> >> URL http://clintongallagher.metromilwaukee.com/
> >>
> >>
> >
> >
>
>|||Is this [1] what you're refrring to? Why would I not just use Enterprise
Manager?
I agree the tools with web interface can be less capable than desktop tools
but -- at the moment -- I don't even have a clue what tasks I need to
consider to move the tables to the hosting provider server. Its not like FTP
where I can just upload files I guess is it? :-( and its not like I don't
have the interest or the skills to learn but I need to learn what to do
before I decide what tools are best to do it that's why I've been asking for
referrals to tutorials.
<%= Clinton Gallagher
[1] http://www.rac4sql.net/qalite_main.asp
"Jens Süßmeyer" <Jens@.[Remove_that][for contacting me]sqlserver2005.de>
wrote in message news:E198A5D7-46A2-489C-BB03-E8E7ECF18625@.microsoft.com...
> To be honest, to me these tools really suck. The WebTools provided by the
> providers often don´t offer all the capabilities that I need, so I used to
> rely on the standard tools like EM and QA, they are the best.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "clintonG" wrote:
>> Thanks for your comments Jens.
>> I can evaluate the same tool you are using but I can connect to my
>> database
>> on the hosted site using Enterprise Manager or a tool with a web
>> interface
>> the hosting provider makes available.
>> <%= Clinton Gallagher
>> "Jens Süßmeyer" <Jens@.remove_this_for_contacting_sqlserver2005.de> wrote
>> in
>> message news:%23dFQ7WArFHA.1788@.tk2msftngp13.phx.gbl...
>> > Due to the limitations for access to the providers SQl Servers I use
>> > QALite to script data from my tables and connect to the remote database
>> > via QA and execute the scripts, thats the best way for me.
>> >
>> > HTH, Jens Süßmeyer.
>> >
>> >
>> > "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in
>> > message
>> > news:OQjsao$qFHA.1788@.tk2msftngp13.phx.gbl...
>> >>I know about BOL. Please take a moment to refer me to any tutorials
>> >>that
>> >>may help me to learn the basics as well as the finer points of moving
>> >>tables and other assets to the hosting provider's server.
>> >>
>> >> <%= Clinton Gallagher
>> >> METROmilwaukee (sm) "A Regional Information Service"
>> >> NET csgallagher AT metromilwaukee.com
>> >> URL http://metromilwaukee.com/
>> >> URL http://clintongallagher.metromilwaukee.com/
>> >>
>> >>
>> >
>> >
>>