Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-01-04 : 03:41:38
|
| Hi all,Could anyone let me know whether VARBINARY(MAX) or File system is BEST for storing large files ? Any pros & cons ?Also , whether SSIS can pick a file from a table with from a VARBINARY(MAX) column and process it ?Thanks in advance,DBAnalyst |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-04 : 04:03:49
|
| The file system is better for storing files, in general terms. Storing the Path / Filename in the database to enable the file to be retrieved.In general:There is more effort retrieving a file from the DB rather than the OSDatabases that include files cause Backups to be bloated - technology for backing up files less frequently - i.e. when they change, or on a rotational basis so that they are sure to be backed up periodically, but not every time - is very mature.Files stored in the database are rarely cached downstream, unlike files stored in the OS (this refers to web delivery)If you have a need to regularly copy the database AND files to other locations then a one-stop-solution of storing the images in the DB may make the publication process easier.For some security issues (only certain users have access to certain files) storing files in the DB can helpSee also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Image,ImagesKristen |
 |
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2007-01-04 : 04:13:38
|
| Thanks Kristen. If a large document or image is stored in column with IMAGE or VARBINARY(MAX) datatype , would these file internally reside in the mdf or any other physical location ?HHA |
|
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2007-01-04 : 04:58:35
|
| What can be the maximum file size we could store in VARBINARY(MAX) column ? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-04 : 05:23:59
|
varbinary(max)'s maximum storage size is 2^31-1 bytes.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-04 : 05:47:05
|
| "would these file internally reside in the mdf or any other physical location"They will be in the MDFKristen |
|
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2007-01-04 : 06:16:58
|
| Thanks Kristen and spirit1. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
using VARBINARY(MAX).