|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > To place an existing table on a different filegroup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
To place an existing table on a different filegroup
|
|
|
| How to place
an existing table on a different filegroup.
(not indexes data,
by using sql scripts (T-SQL))
| |
| Keith Kratochvil 2002-11-20, 2:23 pm |
| You can create a clustered index on the specific filegroup. This will move
the data pages to the filegroup that you specified within the CREATE INDEX
statement.
--
Keith, SQL Server MVP
"sri" <sgorepati@nautilusgroup.com> wrote in message
news:c4f801c290cc$56ca45a0$8af
82ecf@TK2MSFTNGXA03...
> How to place
> an existing table on a different filegroup.
> (not indexes data,
> by using sql scripts (T-SQL))
| |
|
| Thank you for your reply.
>-----Original Message-----
>You can create a clustered index on the specific
filegroup. This will move
>the data pages to the filegroup that you specified within
the CREATE INDEX
>statement.
>
>--
>Keith, SQL Server MVP
>
>
>"sri" <sgorepati@nautilusgroup.com> wrote in message
> news:c4f801c290cc$56ca45a0$8af
82ecf@TK2MSFTNGXA03...
>> How to place
>> an existing table on a different filegroup.
>> (not indexes data,
>> by using sql scripts (T-SQL))
>
>
>.
>
|
|
|
|
|