Reputation: 81342

SQL Server 2000+ which column type to use for storing blobs?

I have to store blob data roughly 10MB per record. Which column type and size should I use for the field?

Upvotes: 1

Answers (3)

marc_s

Reputation: 755321

And with SQL Server 2008, you could even consider putting your VARBINARY(MAX) columns into their own FILESTREAM filegroup and store them in the file system of your SQL Server machine, instead of inside the database.

This works well for blobs that are routinely over 1 MB in size, or if you ever need to store more than 2 GB (limit for VARBINARY(MAX)) in a single blob.

Marc

Upvotes: 0

sihol

Reputation: 41

I would use VARBINARY(MAX) as the IMAGE data type will be dropped in future versions of SQL Server.

Upvotes: 3

leppie

Reputation: 117330

IMAGE, VARBINARY(MAX)

Upvotes: 4

SQL Server 2000+ which column type to use for storing blobs?

Answers (3)

Related Questions