Solved

SQL Server FileStream Question

Posted on 2014-02-07
1
244 Views
Last Modified: 2014-02-22
Just looking for an opinion or suggestions.  I have a windows form application that uses a SQL Server Database on a network server.  Currently this applications creates XML configuration files and stores then in local folders on a users desktop.  I am thinking of storing these XML configuration files into SQL Server table using filestream instead.  I would need to rewrite some code but the benefit would be that all the configuration files will be centralized.  

Is there anything wrong with storing XML files in SQL server via filestream?  Will this impact performance of my application in anyway by retrieving XML configuration files from SQL Server instead of from a local folder?
0
Comment
Question by:hojohappy
1 Comment
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 39843650
Anything wrong with it?  No, not necessarily.  But you have to look at your situation, and decide what is most appropriate.  I just mean there are many things to consider, while you're making this decision.  

Read this.  I believe it is very helpful:   http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx


Personally, I believe FILESTREAM really starts becoming usable when your files are consistently 1MB or better in size.  

If it's much smaller than that, I would just store it as the XML data type.  If you do that, you can query it with XQuery, which I don't believe you can use with the FILESTREAM storage.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now