THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Downloads   Opml View as RSS news feed in XML

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

Planning on using FILESTREAM? Read this first!

Paul Randal just published a list of tips and tricks that will help you get the most out of using FileStream.  The list is based on a longer whitepaper he wrote for Microsoft, which should be published before PASS in November.

http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx

Published Monday, August 25, 2008 8:44 PM by AaronBertrand

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jason Haley said:

August 26, 2008 10:17 AM
 

Arthur Fuller said:

This is more of a question than a comment. We currently subscribe to Bloomberg for data concerning stocks. At the moment we receive an FTP file nightly and import that data into SQL Server. At some point soon, however, we are going to switch to a live feed. Would a FileStream be appropriate for this? One of our guys is working on a c# application to deal with the stream, but that's because we're still using SQL 2005. If a FileStream object is a better approach, it might provide the motivation to upgrade.

Thanks.

August 28, 2008 11:28 AM
 

AaronBertrand said:

Arthur, I guess it depends on what you are doing with the data from the FTP file.  If you are bulk inserting the data into a true table format (several columns, several rows), then FileStream doesn't make much sense.  AFAIK FileStream is meant for handling whole files, not splitting them up.

September 7, 2008 11:14 AM
 

Gabi said:

Hi. Everywhere it's written that FILESTREAM should only be used when you are working with files bigger than 1MB. I got Files from 1KB up to 50MB. My question is now: Should I use FILESTREAM in my case, or not? Hope you have a good advise for me :)

Thank You!

February 9, 2010 9:01 AM
 

AaronBertrand said:

I haven't used FILESTREAM except for a few basic tests, so don't really have any guidance for you.  Have you visited this topic in Books Online?  It may have some information that will help you decide one way the other.

http://msdn.microsoft.com/en-us/library/bb895334.aspx

February 9, 2010 9:08 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication
©2006-2012 SQLblog.comTM
Brought to you by Adam Machanic & Peter DeBetta
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement