Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Filestream data Expand / Collapse
Author
Message
Posted Friday, September 27, 2013 3:06 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, March 18, 2016 8:38 AM
Points: 737, Visits: 844
reminds me of a session at this years SQLBits
Post #1499267
Posted Friday, September 27, 2013 3:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 14, 2016 11:18 AM
Points: 163, Visits: 260
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.
Post #1499272
Posted Friday, September 27, 2013 5:21 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:48 AM
Points: 1,584, Visits: 942
"FILESTREAM, of course" has 11%, so that was a bit sneaky!
Post #1499319
Posted Friday, September 27, 2013 7:18 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:06 AM
Points: 407, Visits: 477
+1 to the excellent question comments :)
Post #1499370
Posted Friday, September 27, 2013 8:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 10, 2016 8:09 AM
Points: 271, Visits: 234
This was one of the SQL Server questions in the MS Exams when I wrote it few years ago
Post #1499409
Posted Friday, September 27, 2013 9:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, February 11, 2015 1:54 PM
Points: 1,922, Visits: 1,396
paul s-306273 (9/27/2013)
"FILESTREAM, of course" has 11%, so that was a bit sneaky!


I love how sassy that option is, though.
Post #1499453
Posted Friday, September 27, 2013 9:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, January 30, 2015 7:36 AM
Points: 2,723, Visits: 4,152
Primo Dang (9/27/2013)
paul s-306273 (9/27/2013)
"FILESTREAM, of course" has 11%, so that was a bit sneaky!


I love how sassy that option is, though.


That's why I chose it as my answer. I wanted to be sassy back.
Post #1499479
Posted Friday, September 27, 2013 12:37 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 8,629, Visits: 7,891
Good question to end the week. Today was hectic enough already.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1499546
Posted Friday, September 27, 2013 3:07 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:31 AM
Points: 3,934, Visits: 2,236
Easy one for a Friday. Thanks Steve!
Post #1499597
Posted Saturday, September 28, 2013 6:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, March 8, 2016 10:23 AM
Points: 2,144, Visits: 613
nice and easy to end the week..
Thanks steve..
Post #1499680
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse