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 Forums Roller Downloads   Opml View as RSS news feed in XML

Aaron Bertrand

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


Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
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

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

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