May 20, 2011 at 9:44 am
Nice question. I learned alot after researching this topic.
May 20, 2011 at 10:11 am
GSquared (5/20/2011)
I can't get your link to work, so can't check what you referenced there, but the question was about Filestream, which is NOT in the database. That's a major part of the whole point for filestream data. That and faster streaming (NTFS stream instead of SQL Server stream).
The correct url to the white paper by Paul Randal is http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx. For some reason the link posted by Richard got the parentheses encoded, left to %28 and right to %29.
Nice question, thank you Steve. The 8.3 got me to scratch my head and forced me to revisit Paul's white paper, which is always a good thing 🙂
Oleg
May 20, 2011 at 10:16 am
Thanks for the question. I had no Idea, got it wrong but learned something.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
May 20, 2011 at 11:55 am
nice question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2011 at 3:48 pm
jeff.mason (5/20/2011)
Richard M Karpel (5/20/2011)
If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as stated in this quote:Storing BLOB data solely within the database (e.g., using the varbinary(max) data type) is limited to 2 gigabytes (GB) per BLOB.
I hate getting answers wrong and went with the SQL only answer, and wish that the question would be qualified as whether stored solely within the database or not.
Other wise a nice challenging question. :w00t:
Uh, I thought FILESTREAM by its very definition was always outside the database files and in the NTFS filesystem....?
The only way I have found that data saved with FILESTREAM enabled will ever be subject to the 2GB rule is if the data gets replicated to another system and the FILESTREAM attribute does not. That is also the only way I can find that FILESTREAM data would not always be outside the database. Since that involves moving the data without the FILESTREAM attribute it certainly IMHO does not count.
May 23, 2011 at 2:16 pm
The first table on this linked page suggests the answer I picked (incorrectly). I need to understand this better:
http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
The article by Paul has not sufficiently illuminated it for me either... yet 🙂
Great question, time to hit the books!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 23, 2011 at 2:23 pm
Peter Trast (5/23/2011)
The first table on this linked page suggests the answer I picked (incorrectly). I need to understand this better:http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
The article by Paul has not sufficiently illuminated it for me either... yet 🙂
Great question, time to hit the books!
Hm, the table in question reads under Filestream that the maximum BLOB size is the NTFS volume size.
Can you help us understand what you don't understand?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 23, 2011 at 2:31 pm
Peter Trast (5/23/2011)
The first table on this linked page suggests the answer I picked (incorrectly). I need to understand this better:http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
The article by Paul has not sufficiently illuminated it for me either... yet 🙂
Great question, time to hit the books!
Peter - I am looking at the first table in this article and it says FILESTREAM "Maximum BLOB size" is "NTFS volume size".
Which answer did this lead you to pick incorrectly?
May 23, 2011 at 5:18 pm
Nice question, you almost had me with the 8.3 option.
May 23, 2011 at 6:47 pm
Craig Farrell (5/23/2011)
Peter Trast (5/23/2011)
The first table on this linked page suggests the answer I picked (incorrectly). I need to understand this better:http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
The article by Paul has not sufficiently illuminated it for me either... yet 🙂
Great question, time to hit the books!
Hm, the table in question reads under Filestream that the maximum BLOB size is the NTFS volume size.
Can you help us understand what you don't understand?
nm, momentary brain lapse... FILESTREAM, not BLOB... wow I need to READ a little more carefully... lol...
BTW, FILESTREAM prevents you from mirroring a db... but it works great with the Copy Database Wizard 🙂
Thanks again all!!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply