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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 file stream or file names in a column

Author  Topic 

sarahmfr
Posting Yak Master

214 Posts

Posted - 2010-04-28 : 11:11:12
I have a column in a table that references documents or powerpoint presentations or images
Performance wise which is better to use file streaming or just save the file name in that column
I am keeping a special directory for saving those files on another server
thanks

sarah

RobertKaucher
Posting Yak Master

169 Posts

Posted - 2010-05-03 : 12:44:15
Sarah,

There are a couple of considerations with filestream. I think this whitepaper from MS will help you out.
http://msdn.microsoft.com/en-us/library/cc949109.aspx

Look down near the middle where it says "When deciding where to store BLOB data, consider the following requirements." This should give you the more specific info you are looking for.

===
http://www.ElementalSQL.com/
Go to Top of Page

Nader
Starting Member

41 Posts

Posted - 2010-05-04 : 21:13:51
Thanks
Go to Top of Page
   

- Advertisement -