Stretch Database Datatype Limitations

Question

Stretch Database Datatype Limitations

Steve Jones - SSC Editor

SSC Guru

Points: 736063
More actions
June 28, 2016 at 8:30 pm

#72644

Comments posted to this topic are about the item Stretch Database Datatype Limitations

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

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

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 1

Wrong. Hmm. Does the "choose 3" mean choose three data types or choose three options from the selection provided? Apparently the former. Don't tick 3 boxes!

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

HappyGeek SSCoach Points: 18729 More actions · Answer 2

Similarly wrong, chose the first three options which seem to be the ones mentioned in the explanation, so the question remains which three are correct?

...

SADSAC SSCrazy Points: 2395 More actions · Answer 3

Good question about an interesting functionality, thanks, Steve

Just a minor fail regarding the options - select 3, yet only 2 accepted as correct?

Carlo Romagnano SSC-Insane Points: 22659 More actions · Answer 4

Carlo Romagnano

SSC-Insane

Points: 22659

June 29, 2016 at 12:51 am

#1887503

Great Steve! 100% wrong.

Louis Hillebrand SSCarpal Tunnel Points: 4982 More actions · Answer 5

Steve, your explanation tells me I'm right, but the result tells me false....

Did you try to Stretch us and run into the limitations of the QOTD ?

Louis.

edwardwill SSCertifiable Points: 5842 More actions · Answer 6

edwardwill

SSCertifiable

Points: 5842

June 29, 2016 at 1:08 am

#1887510

Yet another borked QotD.

Rune Bivrin SSCrazy Eights Points: 8503 More actions · Answer 7

Steve has too much on his hands.

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

Sergiy SSC Guru Points: 110208 More actions · Answer 8

From the explanation:

The other big restriction is on CLR types, which include hierarchyid and spatial types

Seems like the absence of hierarchyid from the "correct answer" list is just a mistake.

_____________
Code for TallyGenerator

Uwe Ricken Hall of Fame Points: 3169 More actions · Answer 9

Steve,

I answered all three options correct:

- text/ntext

- XML

- CLR datatypes

but the answer is marked as wrong. In your given solution you mention exactly the same options.

Can you check it?

Best from Germany...

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

paul s-306273 SSChampion Points: 10730 More actions · Answer 10

Confidently expected to get this right...like lots of others!

Thom A SSC Guru Points: 99127 More actions · Answer 11

Feel a little cheated that I had to choose 3. Was confident on the first 2, guessed the 3rd, to be told the 2 I was confident on were right and that there was no 3rd 🙁

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 12

paul s-306273 (6/29/2016)
Confidently expected to get this right...like lots of others!

same

MattieNH SSCertifiable Points: 7463 More actions · Answer 13

Actually, I'd like to hear from the 2% who got this correct.

csecord Mr or Mrs. 500 Points: 513 More actions · Answer 14

He was talking about data types so the correct answers could have been

-text/ntext

- XML

Or

-text/ntext

- CLR

I am guessing because I got it wrong by choosing 4 data types