Stewart,

Here is a TechNet article on storing large objects:
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx?mfr=true

S. Davey (4/27)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


>>> "Stewart Rae "
<mssqldba-ezmlmshield-x53116013.[Email address protected] 04/26/07
7:53 PM >>>
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?




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page