November 1, 2011 at 6:04 am
Wow, did I have to think on this one. Thanks for the interesting question.
http://brittcluff.blogspot.com/
November 1, 2011 at 6:05 am
L' Eomot Inversé (11/1/2011)
Excellent question.I wonder if there's another on sql_variant in the pipleline?
Not at this stage, at least not by me. I was going to do one based on the weird sort order of SQL_VARIANT, but it's too obtuse even for me 😀
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
November 1, 2011 at 6:06 am
Britt Cluff (11/1/2011)
Wow, did I have to think on this one. Thanks for the interesting question.
Me too - and I wrote the thing (a month or so ago).
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
November 1, 2011 at 6:20 am
Only row 2 matches the explicit Latin1_General_CI_AS collation in the query.
I see one row. Which is the other one?
November 1, 2011 at 6:29 am
Great question, I sure learned something new this morning.
November 1, 2011 at 6:45 am
Rich Weissler (11/1/2011)
Only row 2 matches the explicit Latin1_General_CI_AS collation in the query.
I see one row. Which is the other one?
That's row number 2, not two rows.
November 1, 2011 at 6:51 am
Great question that made me think. Great explanation.
Thanks,
Matt
November 1, 2011 at 7:01 am
SQL Kiwi (11/1/2011)
L' Eomot Inversé (11/1/2011)
Excellent question.I wonder if there's another on sql_variant in the pipleline?
Not at this stage, at least not by me. I was going to do one based on the weird sort order of SQL_VARIANT, but it's too obtuse even for me 😀
That's the very one I was wondering about, as it seems a natural next question (as you've defined a UNIQUE constraint on a variant column, there must be a total order on SQL_variant to produce the index that supports that constraint. It's not really all that obtuse, if I remember the ordering rules correctly. In fact I'm tempted to ask that one myself if you are not going to. Or even ask two or three questions on it (on second thoughts, maybe that I'm contemplating two or three questions means it is a bit obtuse).
Tom
November 1, 2011 at 7:23 am
cfradenburg (11/1/2011)That's row number 2, not two rows.
Doh! That's clear as day now. Thank you! (Both for the answer, and the patience.) (I learned two things today! First, a little more about SQL_Variant. Second, don't try to comprehend the QotD answer before coffee.)
November 1, 2011 at 7:41 am
Very interesting question.
November 1, 2011 at 8:25 am
Thanks Kiwi! Another great great question that had me looking more closely at something I hadn't yet tinkered with too much. Cheers mate!
November 1, 2011 at 9:08 am
cool 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
November 1, 2011 at 9:20 am
Britt Cluff (11/1/2011)
Wow, did I have to think on this one. Thanks for the interesting question.
+ 1 - Thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
November 1, 2011 at 9:23 am
Interesting stuff, thanks!
November 1, 2011 at 9:49 am
Nice one, thanks
Iulian
Viewing 15 posts - 16 through 30 (of 41 total)
You must be logged in to reply to this topic. Login to reply