Post reply

Filestream storage

  • March 17, 2015 at 10:27 pm

    #295257

    Comments posted to this topic are about the item Filestream storage

  • March 17, 2015 at 10:50 pm

    #1784649

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • March 18, 2015 at 1:50 am

    #1784664

    Great question, thanks!

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

  • March 18, 2015 at 5:21 am

    #1784725

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

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • March 18, 2015 at 8:59 am

    #1784801

    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.

  • March 18, 2015 at 10:05 am

    #1784822

    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:

  • March 18, 2015 at 10:26 am

    #1784831

    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

  • March 18, 2015 at 11:26 am

    #1784854

    Good question, Thanks

  • March 18, 2015 at 12:12 pm

    #1784864

    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.

  • March 19, 2015 at 2:40 am

    This was removed by the editor as SPAM

  • March 19, 2015 at 3:58 am

    #1784993

    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)

  • March 19, 2015 at 6:35 am

    #1785016

    Thanks for the question.

  • March 19, 2015 at 11:53 am

    #1785181

    Nice and easy - thanks, Steve!

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

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