Filestream data

Question

Post reply

Filestream data

Steve Jones - SSC Editor

SSC Guru

Points: 736430
More actions
September 26, 2013 at 8:27 pm

#74477

Comments posted to this topic are about the item Filestream data
September 27, 2013 at 1:36 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 24 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Nice question to end the week ............

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

kapil_kk SSC-Insane Points: 21316 More actions · Answer 2

bitbucket-25253 (9/26/2013)
Nice question to end the week ............

+1 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 3

Mr. Kapsicum

SSCertifiable

Points: 6128

September 26, 2013 at 11:35 pm

#1653852

nice question,,,, learned something.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

Didn't even have to think for this one. Which is nice for a Friday 😀

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

sqlnaive SSCoach Points: 17437 More actions · Answer 5

Koen Verbeeck (9/26/2013)
Didn't even have to think for this one. Which is nice for a Friday 😀

Same here. After long long time, I didn't had to think twice. Happy weekend. Cheers... 🙂

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 6

Don't often use FILESTREAM so was nice to h ave to go and do some 'forced' reading on it.

Thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 7

Carlo Romagnano

SSC-Insane

Points: 22680

September 27, 2013 at 12:57 am

#1653874

Perfect qotd and explanation.

Thanks!

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 8

Easy one. Thanks.

Just to close the gaps, the option should have been VARBINARY(MAX) instead of just VARBINARY because anything else like VARBINARY(N) {N being a natural number up to 8000} won't work but the explanation covers it nicely. 🙂

create table #t(i VARBINARY(8000) FILESTREAM)

Incorrect syntax near 'FILESTREAM'.

heymiky SSCarpal Tunnel Points: 4875 More actions · Answer 9

heymiky

SSCarpal Tunnel

Points: 4875

September 27, 2013 at 3:06 am

#1653921

reminds me of a session at this years SQLBits 🙂

Dscheypie SSCommitted Points: 1545 More actions · Answer 10

What I found even more interesting:

"The standard varbinary(max) limitation of 2-GB file sizes does not apply to BLOBs that are stored in the file system."

The file size is then, as I understood, only restricted by NTFS. Which could mean: We are already able to store documents bigger than 2 GB into SQL Server. THAT was the most interesting thing for me!

That might explain why NVARCHAR(max) or VARCHAR(max) does not apply: It is not implemented for those data types. Wouldn't be necessary anyway, I know.

Nice question, Steve: Thanks!

________________________________________________________
If you set out to do something, something else must be done first.

paul s-306273 SSChampion Points: 10730 More actions · Answer 11

"FILESTREAM, of course" has 11%, so that was a bit sneaky!

logitestus SSCrazy Points: 2928 More actions · Answer 12

logitestus

SSCrazy

Points: 2928

September 27, 2013 at 7:18 am

#1654012

+1 to the excellent question comments 🙂

DrKiller Right there with Babe Points: 780 More actions · Answer 13

This was one of the SQL Server questions in the MS Exams when I wrote it few years ago 🙂