columns in different filegroups

hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
or file and other column of the same table to another filegroup or
file?... or i need to create two tables? thanks
The short answer is to use two tab les. The long answer is that you can
have text/image columns in a separate filegroup.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133290695.567297.250330@.g47g2000cwa.googlegr oups.com...
> hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
> or file and other column of the same table to another filegroup or
> file?... or i need to create two tables? thanks
>
|||ok, thanks

columns in different filegroups

hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
or file and other column of the same table to another filegroup or
file?... or i need to create two tables? thanksThe short answer is to use two tab les. The long answer is that you can
have text/image columns in a separate filegroup.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133290695.567297.250330@.g47g2000cwa.googlegroups.com...
> hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
> or file and other column of the same table to another filegroup or
> file?... or i need to create two tables? thanks
>|||ok, thanks

columns in different filegroups

hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
or file and other column of the same table to another filegroup or
file?... or i need to create two tables? thanksThe short answer is to use two tab les. The long answer is that you can
have text/image columns in a separate filegroup.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133290695.567297.250330@.g47g2000cwa.googlegroups.com...
> hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
> or file and other column of the same table to another filegroup or
> file?... or i need to create two tables? thanks
>|||ok, thanks