Filestream files

Question

Filestream files

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
January 8, 2015 at 8:20 pm

#74265

Comments posted to this topic are about the item Filestream files
January 9, 2015 at 1:38 am

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 2

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

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.

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

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/

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 5

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.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

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.

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 7

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!

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

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 & Best Regards,
Hany Helmy
SQL Server Database Consultant