Filestream files

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

  • Easy one, thanks Steve.

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

  • Thank you for the post, Steve, interesting one.

    From the local_help, based on this I was able to select the choice which was right.

    FILESTREAM data must be stored in FILESTREAM filegroups. A FILESTREAM filegroup is a special filegroup that contains file system directories instead of the files themselves. These file system directories are called data containers. Data containers are the interface between Database Engine storage and file system storage.

    Generally speaking, I(/we) add a .mdf or .ndf to a file group when creating additional database file. But seeing .fdf and .fsm I was in the "assumption" of something new in 2014; then I thought "why on earth Microsoft would ever do that?" 😎

    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 an interesting question. Not having been able to play with them yet, I learned something new. Always a good way to start the day.

  • Good question.

    What I missed in the explanation is that the filestream filegroup does have a physical path, but this is to a directory, not a file. And directories normally don't have extensions.

    (BTW, I never tried if I get an error if I do assign an extension to a directory name...)


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Hugo Kornelis (1/9/2015)


    Good question.

    What I missed in the explanation is that the filestream filegroup does have a physical path, but this is to a directory, not a file. And directories normally don't have extensions.

    (BTW, I never tried if I get an error if I do assign an extension to a directory name...)

    You can't assign an extension, but a folder named [FS.fsx] is a valid folder name. You can also assign this as the Filestream path.

  • Hugo Kornelis (1/9/2015)


    ...(BTW, I never tried if I get an error if I do assign an extension to a directory name...)

    Just tried the creation part with FS where I assigned the extn to the folder, it works properly, no errors. (as of now)

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

  • Nice, fairly easy question to end the week. I haven't worked with filestream data yet, but it makes sense that if you are storing data in the local file system, there is no need for a data file to store it as well, so that allowed me to choose the correct answer. 🙂

    Thanks, Steve. Have a nice weekend!

  • Steve Jones - SSC Editor (1/9/2015)


    Hugo Kornelis (1/9/2015)


    Good question.

    What I missed in the explanation is that the filestream filegroup does have a physical path, but this is to a directory, not a file. And directories normally don't have extensions.

    (BTW, I never tried if I get an error if I do assign an extension to a directory name...)

    You can't assign an extension, but a folder named [FS.fsx] is a valid folder name. You can also assign this as the Filestream path.

    Hmmm, that was totally new 4 me, learned somthin new 2day, thanx both of u.

  • Thanks for the question.

  • +1 - thanks for the refresher.

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

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