LOB Data

Question

Post reply

LOB Data

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
March 10, 2011 at 10:25 pm

#233224

Comments posted to this topic are about the item LOB Data
March 11, 2011 at 1:05 am

This was removed by the editor as SPAM
March 11, 2011 at 1:32 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 42 total)

You must be logged in to reply to this topic. Login to reply

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

Ummm, the 'select all that apply' choices are a radio button, can only pick one. Not good.

- Craig Farrell

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

tommyh SSCertifiable Points: 6302 More actions · Answer 2

Craig Farrell (3/10/2011)
Ummm, the 'select all that apply' choices are a radio button, can only pick one. Not good.

I second this. Besides the link to "support" the answer is crap. "Filestream" aint no datatype. Its an attribute on a varbinary(max) datatype.

Datatypes

http://msdn.microsoft.com/en-us/library/ms187752.aspx

Filestream

http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.aspx

/T

Vera-428803 SSCrazy Points: 2439 More actions · Answer 3

Vera-428803

SSCrazy

Points: 2439

March 11, 2011 at 12:31 am

#1297455

Can't select more than one with radiobuttons.

e-ghetto SSChasing Mays Points: 616 More actions · Answer 4

The preferred LOB (Large OBject) types in SQL Server are ...

Preferred by whom? You can also use varbinary(max):

http://msdn.microsoft.com/en-us/library/ms178158.aspx

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 5

Why radio buttons for multiple choice question? Only one could be selected.

tommyh SSCertifiable Points: 6302 More actions · Answer 6

stewartc-708166 (3/11/2011)
The options listed are classified as Large-Value data types, not LOB's
refer:
SQL2005: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.90).aspx
SQL2008: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.100).aspx
SQL2008R2: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.105).aspx

They are actually both. From the URL that i posted:

- Large value data types: varchar(max), nvarchar(max), and varbinary(max)
- Large object data types: text, ntext, image, varchar(max), nvarchar(max), varbinary(max), and xml

/T

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 7

Nice easy question! It was obvious that more than one answer was meant to be correct, so I took a punt and figured that the first had been marked as correct, and the question had been published before the other ones were also selected.

Rune Bivrin SSCrazy Eights Points: 8512 More actions · Answer 8

This question is just completely broken. There's a big difference between "preferred" and "valid". And to claim that varbinary(max) isn't a LOB is a bit daft.

Just because you're right doesn't mean everybody else is wrong.

M&M SSC-Insane Points: 21700 More actions · Answer 9

Everyone should be given at least 5 bonus points irrespective of right or wrong answer.

M&M

M&M SSC-Insane Points: 21700 More actions · Answer 10

M&M

SSC-Insane

Points: 21700

March 11, 2011 at 1:38 am

#1297473

Not 5 but 10 😛

M&M

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 11

I agree with you guys. we all should be given 10 points.:-P

Toreador SSChampion Points: 11365 More actions · Answer 12

...and XML is wrong, but the explanation then states that XML is one of the valid types.

Perhaps this is anither of those questions which were changed by the writer but the first version published by mistake?