Need help partitioning a field on a sql 2008 table to a different filegroup

Question

Hi folks, in a previous question i asked, the suggested answer was for me to partition my field onto another Filegroup, keeping the field in the same table.

I'm not sure how to do this.

I've tried to google for things like partition table, partition view, etc. Could anyone provide me with some links or some sample sql code?

DB Server is Sql 2008.

Table Schema

FooId  INT PK IDENTITY
Name   VARCHAR(100) NOT NULL
Boo    VARCHAR(100) NOT NULL
BlahId INT NOT NULL
Photo  VARBINARY(MAX)     <-- This field wants to go onto another filegroup.
                             Can be null.

cheers!

Answer 1

You need to use the TEXTIMAGE ON clause in CREATE TABLE.

Answer 2

I prefer to keep files on a file server and just have the database store a path/file name. this would make the database small, easy to transfer to development, etc.

Answer 3

Anyone know how to move columns on an existing table without dropping and recreating the table? TEXTIMAGE_ON only seems to be available for CREATE TABLE.