需要帮助将sql 2008表上的字段分区到不同的文件组

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?

我试图谷歌搜索分区表,分区视图等等。任何人都可以提供一些链接或一些示例sql代码?

DB Server is Sql 2008.

数据库服务器是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.

1 个解决方案

#1

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

您需要在CREATE TABLE中使用TEXTIMAGE ON子句。