<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Tom Thomson
»
Variant Order 2
27 posts, Page 3 of 3
««
«
1
2
3
Variant Order 2
Rate Topic
Display Mode
Topic Options
Author
Message
L' Eomot Inversé
L' Eomot Inversé
Posted Wednesday, December 07, 2011 7:58 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 2:57 PM
Points: 7,079,
Visits: 7,121
Evil Kraig F (12/6/2011)
Rob Schripsema (12/5/2011)
Great question. Not what I would have expected....but then, many aspects of SQLVariants are not what I would expect.
Agreed, it's like opening Pandora's Box. I'm not even sure what led Tom to finding this nugget, nevermind how I'd go about finding the full answer if he hadn't spoon-fed me what was going on in a reasonable amount of time.
Variant can burn from everything I've been seeing on the complexity of its rulesets.
What got me thinking of doing questions on variant order was a comment by someone (I think it was by Hugo in response to an earlier question, but not at all sure) that he had thought of doing a question on variant order but decided the ordering rules were too complex. I had come across variant ordering being misused for a purpose other than indexing some years back, and knew that people using SQL to create EAV systems sometimes got caught up in it. I knew that it was quite well documented in BoL, and the only things I couldn't remember about it was how to discover the locale version (the locale id was OK, but not the version) associated with a collation (couldn't remember that because I had never known it - and still don't, I haven't found it documented anywhere, haven't even looked for it much) and what happened with the newest types (date and datetime2). So I thought that maybe some questions would be amusing SQL trivia, because the rules are not really at all bizarre or complex.
As for using this stuff - well, you can probably guess from my use of the word "misuse" above that I believe that the order on SQL_VARIANT should be used only to support the construction of indexes, especially those associated with primary key and unique constraints. If people want to mess about with EAV models and worry about the order of SQL_VARIANT (beyond knowing that variant columns can be used in indexes and keys) they are, in my view, misguided (on both counts). But the rules are still fun SQL trivia.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1217928
Hugo Kornelis
Hugo Kornelis
Posted Wednesday, December 07, 2011 8:15 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 5,232,
Visits: 7,023
L' Eomot Inversé (12/7/2011)
What got me thinking of doing questions on variant order was a comment by someone (I think it was by Hugo in response to an earlier question, but not at all sure) that he had thought of doing a question on variant order but decided the ordering rules were too complex.
Nope, not me. I am innocent!
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1217944
Iulian -207023
Iulian -207023
Posted Thursday, December 08, 2011 1:38 AM
SSC Eights!
Group: General Forum Members
Last Login: Saturday, March 16, 2013 9:53 AM
Points: 847,
Visits: 768
Thank you for the question
Iulian
Post #1218428
L' Eomot Inversé
L' Eomot Inversé
Posted Sunday, December 11, 2011 5:19 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 2:57 PM
Points: 7,079,
Visits: 7,121
Hugo Kornelis (12/7/2011)
L' Eomot Inversé (12/7/2011)
What got me thinking of doing questions on variant order was a comment by someone (I think it was by Hugo in response to an earlier question, but not at all sure) that he had thought of doing a question on variant order but decided the ordering rules were too complex.
Nope, not me. I am innocent!
Quite right. It wasn't you, it was Paul, in the discussion on his Collation and SQL_VARIANT question (QOTD for 1st November), see
this post
and my
response
to it.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1219910
charlietuna
charlietuna
Posted Thursday, December 15, 2011 12:26 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, January 18, 2013 9:32 AM
Points: 188,
Visits: 54
Erudite indeed, but I don't think this is ever going to matter to me.
Post #1222200
Dineshbabu
Dineshbabu
Posted Friday, January 18, 2013 5:09 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746,
Visits: 435
440692 I am just a number (12/5/2011)
Thank you
A very interesting question.
Alas, I could see no other way to work out the answer, than to run the code.
+1
--
Dineshbabu
Desire to learn new things..
Post #1408833
Dineshbabu
Dineshbabu
Posted Friday, January 18, 2013 5:12 AM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746,
Visits: 435
I don't whether i will use it in the mere future. Eventhough if i use i have to go through the explaination once again on that time.
--
Dineshbabu
Desire to learn new things..
Post #1408835
« Prev Topic
|
Next Topic »
27 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
