Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Thursday, November 20, 2014 2:59 AM
Points: 728, Visits: 782
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: Monday, August 25, 2014 10:53 PM
Points: 160, Visits: 235
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:30 AM
Points: 1,417, Visits: 806
"FILESTREAM, of course" has 11%, so that was a bit sneaky!
Post #1499319
Posted Friday, September 27, 2013 7:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 295, Visits: 342
+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: Yesterday @ 7:01 AM
Points: 218, Visits: 182
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: Today @ 3:43 PM
Points: 1,860, Visits: 1,333
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: 2 days ago @ 10:23 AM
Points: 2,630, Visits: 4,041
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
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:35 AM
Points: 4,482, Visits: 3,938
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: Today @ 12:20 PM
Points: 3,397, Visits: 2,023
Easy one for a Friday. Thanks Steve!
Post #1499597
Posted Saturday, September 28, 2013 6:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
nice and easy to end the week..
Thanks steve..
Post #1499680
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse