Stretch Database Datatype Limitations

Question

Post reply

Stretch Database Datatype Limitations

Viewing 14 posts - 16 through 28 (of 28 total)

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

Junior Galvão - MVP SSCertifiable Points: 6974 More actions · Answer 1

Hi,

Please check the question. I select all three options, but get the message incorrect response.

George Vobr SSChampion Points: 10068 More actions · Answer 2

Rune Bivrin (6/29/2016)
Steve has too much on his hands.

+1

The question is interesting, the typos I don't mind, at least I learned

again something new. Documentation is at a good level. Thanks, Steve

gary.mazzone SSCarpal Tunnel Points: 4787 More actions · Answer 3

gary.mazzone

SSCarpal Tunnel

Points: 4787

June 29, 2016 at 6:46 am

#1887594

Good question bad answer 2 != 3

dhober Ten Centuries Points: 1084 More actions · Answer 4

Reminds me of an old teacher of mine. They would purposefully mark a multiple-choice answer on a test as incorrect, so that you'd have to explain to them why the answer was the correct one in order to receive proper credit.

Bobby Russell SSCrazy Points: 2801 More actions · Answer 5

Got told I was wrong again for the right answer. +1

Revenant SSC-Forever Points: 42467 More actions · Answer 6

Steve, I think this QotD was rather poorly worded. You should reconsider the 'wrong' replies.

J DBA SSCertifiable Points: 5008 More actions · Answer 7

Obviously a case of the hierarchyid option not being checked in the official answers. :Whistling:

Thanks Steve for the question about a new feature.

JDBA

Steve Jones - SSC Editor SSC Guru Points: 737991 More actions · Answer 8

Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

Points awarded back.

My apologies.

Sergiy SSC Guru Points: 110209 More actions · Answer 9

Steve Jones - SSC Editor (6/29/2016)
Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.
Points awarded back.
My apologies.

No, idiocy is not yours here.

Yours is a simple mistake, a typo.

Idiocy is of those who have already "proved" here how the mistake was a correct answer.

_____________
Code for TallyGenerator

Revenant SSC-Forever Points: 42467 More actions · Answer 10

Sergiy (6/29/2016)
Steve Jones - SSC Editor (6/29/2016)
Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.
Points awarded back.
My apologies.
No, idiocy is not yours here.
Yours is a simple mistake, a typo.
Idiocy is of those who have already "proved" here how the mistake was a correct answer.

Well said, Sergyi.

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Easy question, which I got wrong by not noticing "select 3" and just picking the first obvious exclusion. The square boxes should have stopped me clicking submit but I only noticed them (are started cursing) after my finger had started moving and didn't react fast enough.

Stupid careless me! :doze::blush::ermm:

Tom

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 12

Per the link : "http://www.sqlshack.com/the-dbas-guide-to-stretch-database/"

Below are the data types which are not supported:

filestream

timestamp

sql_variant

XML

geometry

geography

hierarchyid

CLR user-defined types (UDTs)

-- Considering this I was thinking why not "dateoffset", in place of text/image?

Thanks.

Sergiy SSC Guru Points: 110209 More actions · Answer 13

SQL-DBA-01 (7/3/2016)
Per the link : "http://www.sqlshack.com/the-dbas-guide-to-stretch-database/"
Below are the data types which are not supported:
filestream
timestamp
sql_variant
XML
geometry
geography
hierarchyid
CLR user-defined types (UDTs)
-- Considering this I was thinking why not "dateoffset", in place of text/image?

Apparently, the list in the article is not correct.

Unfortunately, factual errors are quite common in IT related publications.

I even once won a bet that I'll find a false statement in any of books published by MS.

So, - do not trust strangers from Internet!

Even when they carry some heavy medals of honour.

_____________
Code for TallyGenerator

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

I like the question and I even answered late enough that the tick 3 was not an issue. I do like that the text option was included.

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

Stretch Database Datatype Limitations

Cookies on SQLServerCentral