Hi everyone - happy friday :)

I have a question regarding filegroups in SQL Server 2000.

Is it better to have TEXT and BINARY columns in the same filegroup as
the table they belong to, or store them in a separate filegroup?

i.e. which is better, this:

CREATE TABLE Foo
(
FooID INT NOT NULL PRIMAY KEY,
FooName VARCHAR(1000) NOT NULL,
FooData TEXT NULL
)
ON PRIMARY_FILEGROUP

... or this:

CREATE TABLE Foo
(
FooID INT NOT NULL PRIMAY KEY,
FooName VARCHAR(1000) NOT NULL,
FooData TEXT NULL
)
ON PRIMARY_FILEGROUP
TEXTIMAGE ON BLOB_FILEGROUP


What are the pro's and con's of storing your BLOB's on a separate
filegroup to your data?



MS Sql Server LazyDBA home page