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, July 24, 2014 7:19 AM
Points: 728, Visits: 771
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, October 31, 2013 11:22 AM
Points: 160, Visits: 231
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: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
"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: Wednesday, July 16, 2014 11:25 PM
Points: 240, Visits: 304
+1 to the excellent question comments :)
Post #1499370
Posted Friday, September 27, 2013 8:17 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 184, Visits: 155
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: 2 days ago @ 7:53 AM
Points: 1,723, Visits: 1,199
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: Today @ 8:57 AM
Points: 2,518, Visits: 3,718
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
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 @ 1:50 PM
Points: 3,978, Visits: 2,994
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: Sunday, July 27, 2014 10:34 AM
Points: 3,261, Visits: 1,955
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, July 7, 2014 9:38 AM
Points: 1,780, Visits: 582
nice and easy to end the week..
Thanks steve..
Post #1499680
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse