Filestream storage

  • Comments posted to this topic are about the item Filestream storage

  • I though it`s not working with Express edition! good that I made same R&D b4 answer 😉

  • Great question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I don't have to use Express, so I had to look it up too. Thanks.

  • Hi Steve

    Sorry, if I am confused, but the below link says:

    "https://technet.microsoft.com/en-us/library/bb895334(v=sql.110).aspx"

    SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.

    So I selected option 4 as does not include "filestream data container"

    Thanks.

  • SQL-DBA-01 (3/18/2015)


    Hi Steve

    Sorry, if I am confused, but the below link says:

    "https://technet.microsoft.com/en-us/library/bb895334(v=sql.110).aspx"

    SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.

    So I selected option 4 as does not include "filestream data container"

    So you found a link that says FILESTREAM works in SQL Express, and then selected the option that says FILESTREAM doesn't work in SQL Express? :ermm:

  • SQL-DBA-01 (3/18/2015)


    Hi Steve

    Sorry, if I am confused, but the below link says:

    "https://technet.microsoft.com/en-us/library/bb895334(v=sql.110).aspx"

    SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.

    So I selected option 4 as does not include "filestream data container"

    That means that the 10GB file limit does not include the size of the filestream data container in the limitation.

    In other words, 10GB database size is just the sum of the data files. The FILESTREAM data container (this is not a data file in the traditional sense) is completely separate.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Good question, Thanks

  • Thank you for the post, Steve, really good one. (this is one of those question where I chose the answer with theoretical analysis based on practical experience- was sure of expr edt support of FS and was also sure of the limited 10GB db files has no involvement, but was not sure of FS limitation 10 GB or the disk. So selected the disk limit and selecting the first one did not seem right.) 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • This was removed by the editor as SPAM

  • Thanks for this easy question.

    FileStream is the only possibility to "rub off" the limitation of 10 GB for the storage of data in a SQL Server Express Edition.

    I got at least 15 answered questions on forums but I always warned that the FileStream is not evident to use in an application ( really tricky to code and at least in the 1st version of the BOL not explained in a clear way)

  • Thanks for the question.

  • Nice and easy - thanks, Steve!

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply