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: Wednesday, May 27, 2015 12:31 AM
Points: 728, Visits: 810
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: Wednesday, July 8, 2015 11:28 PM
Points: 160, Visits: 242
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, July 17, 2015 7:46 AM
Points: 1,442, Visits: 825
"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: Friday, August 28, 2015 10:11 AM
Points: 375, Visits: 439
+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, August 13, 2015 4:22 AM
Points: 262, Visits: 218
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 @ 6:30 AM
Points: 6,433, Visits: 5,875
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: 2 days ago @ 8:41 PM
Points: 3,688, Visits: 2,150
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: 2 days ago @ 11:38 AM
Points: 2,077, Visits: 602
nice and easy to end the week..
Thanks steve..
Post #1499680
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse