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: Monday, May 11, 2015 3:35 AM
Points: 728, Visits: 809
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: Thursday, May 14, 2015 8:40 AM
Points: 1,428, Visits: 818
"FILESTREAM, of course" has 11%, so that was a bit sneaky!
Post #1499319
Posted Friday, September 27, 2013 7:18 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 20, 2015 3:14 PM
Points: 365, Visits: 410
+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: Friday, May 15, 2015 3:52 AM
Points: 241, Visits: 210
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
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:10 AM
Points: 5,595, Visits: 5,070
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: Friday, May 22, 2015 8:32 AM
Points: 3,583, Visits: 2,098
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: Friday, March 13, 2015 12:40 PM
Points: 2,070, Visits: 595
nice and easy to end the week..
Thanks steve..
Post #1499680
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse