Post reply

Today's Random Word!

  • July 24, 2012 at 8:31 am

    #1516846

    massive latency

  • July 24, 2012 at 9:37 am

    #1516899

    Ray K (7/24/2012)

    Ichiro

    (says the happy Yankee fan this morning!)

    Suzuki!

  • July 24, 2012 at 9:40 am

    #1516901

    Cliff Jones (7/24/2012)

    Ray K (7/24/2012)

    Ichiro

    (says the happy Yankee fan this morning!)

    Suzuki!

    Honda

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • July 24, 2012 at 9:52 am

    #1516915

    Daniel Bowlin (7/24/2012)

    massive latency

    "Standing in a line for a Disneyland Attraction"

  • July 24, 2012 at 12:31 pm

    #1517021

    Ray K (7/24/2012)

    Ichiro

    (says the happy Yankee fan this morning!)

    There goes another great ball player I can no longer cheer for :sick:

    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

  • July 24, 2012 at 12:53 pm

    #1517032

    L' Eomot Inversé (7/23/2012)

    ChrisM@Work (7/23/2012)

    SQLRNNR (7/23/2012)

    C6H12O6

    6-(hydroxymethyl)oxane-2,3,4,5-tetrol

    Jason's C6H12O6 is a nasty ambiguous formula. ChrisW's thing is less ambiguous (but still ambiguous).

    There's a nasty ambiguous word for it: hexose; but it's not quite as ambiguous as the formula.

    It's 40 years since I studied any chemistry, and I haven't used any of it since 1970, but I reckon that there are hordes (at least 136) of different compounds called hexose, some (at least 60) of which occur naturally, some others we can manufacture, and yet others of which neither occur naturally (at least on earth) nor have we manufactured them yet (as far as I know). In addition there are 9 different inositols (CHOH)6. So that's at least 145 things which are each C6H12O6.

    16 straight-chain aldohexoses H(CHOH)5CHO (7 naturally occurring ones, and another 9 theoretically possible ones). These are short-lived transient forms, which occur when one of the ring form hexopyranoses temporarily opens out before reforming into a different ring form (which might not be a hexopyranose).

    32 Hexopyranoses - ring forms with topology O(CHOH)4CH2.CHOH, 2 related to each of the above aldohexoses (14 naturally occurring, 2 of which are - I think - used as [the main ingredient of] table sugar, and 18 others are theoretically possible). a-D-Glucopyranose and ß-D-Glucopyranose are the two forms in table sugar, I think, but I could have that wrong. But these 32 are really 96, because each of the 32 comes as 3 torsion/rotation isomers.

    I think ChrisM's "6-(hydroxymethyl)oxane-2,3,4,5-tetrol" is probably generally used for any of the dextrorotatory D-hexopyranoses (not all D-hexopyranoses are dextrorotatory, despite the D- prefix) although it looks as if it ought to apply to all 32 hexopyranoses, but maybe it's some other sbset of them.

    16 Hexofuranoses – ring forms with topology OCHCH2OH(CHOH)3COH.CH2OH, derived from the straight aldohoses, of which 7 do occur naturally but never in solid form. Or are there 32, not 16?

    8 ketohexoses CH2OH(CHOH)3COCH2OH of which 4 occur naturally. These are formed as transients when a Hexofuranose temporarity opens out, before forming a new ring (which may not be a hexofuranose).

    Inositol, an alcohol formed by a ring of 6 CHOH groups, has 5 naturally occurring forms; there are 4 other possible forms.

    Maybe there are some more forms of C6H12O6 – I'm no expert.

    But there's no word that I believe is exactly as ambiguous as Jason's formula: C6H12O6. The nearest is "hexose", which has only 136 different meanings (as far as I know), and C6H12O6 represents 145 different things (of course there may be some C6H12O6 which I don't know about, it may be even more ambiguous that 145 possible meanings suggests).

    And what pray tell are these in laymans terms?

  • July 24, 2012 at 2:30 pm

    #1517073

    L' Eomot Inversé (7/23/2012)

    ChrisM@Work (7/23/2012)

    SQLRNNR (7/23/2012)

    C6H12O6

    6-(hydroxymethyl)oxane-2,3,4,5-tetrol

    Jason's C6H12O6 is a nasty ambiguous formula. ChrisW's thing is less ambiguous (but still ambiguous).

    There's a nasty ambiguous word for it: hexose; but it's not quite as ambiguous as the formula.

    It's 40 years since I studied any chemistry, and I haven't used any of it since 1970, but I reckon that there are hordes (at least 136) of different compounds called hexose, some (at least 60) of which occur naturally, some others we can manufacture, and yet others of which neither occur naturally (at least on earth) nor have we manufactured them yet (as far as I know). In addition there are 9 different inositols (CHOH)6. So that's at least 145 things which are each C6H12O6.

    16 straight-chain aldohexoses H(CHOH)5CHO (7 naturally occurring ones, and another 9 theoretically possible ones). These are short-lived transient forms, which occur when one of the ring form hexopyranoses temporarily opens out before reforming into a different ring form (which might not be a hexopyranose).

    32 Hexopyranoses - ring forms with topology O(CHOH)4CH2.CHOH, 2 related to each of the above aldohexoses (14 naturally occurring, 2 of which are - I think - used as [the main ingredient of] table sugar, and 18 others are theoretically possible). a-D-Glucopyranose and ß-D-Glucopyranose are the two forms in table sugar, I think, but I could have that wrong. But these 32 are really 96, because each of the 32 comes as 3 torsion/rotation isomers.

    I think ChrisM's "6-(hydroxymethyl)oxane-2,3,4,5-tetrol" is probably generally used for any of the dextrorotatory D-hexopyranoses (not all D-hexopyranoses are dextrorotatory, despite the D- prefix) although it looks as if it ought to apply to all 32 hexopyranoses, but maybe it's some other sbset of them.

    16 Hexofuranoses – ring forms with topology OCHCH2OH(CHOH)3COH.CH2OH, derived from the straight aldohoses, of which 7 do occur naturally but never in solid form. Or are there 32, not 16?

    8 ketohexoses CH2OH(CHOH)3COCH2OH of which 4 occur naturally. These are formed as transients when a Hexofuranose temporarity opens out, before forming a new ring (which may not be a hexofuranose).

    Inositol, an alcohol formed by a ring of 6 CHOH groups, has 5 naturally occurring forms; there are 4 other possible forms.

    Maybe there are some more forms of C6H12O6 – I'm no expert.

    But there's no word that I believe is exactly as ambiguous as Jason's formula: C6H12O6. The nearest is "hexose", which has only 136 different meanings (as far as I know), and C6H12O6 represents 145 different things (of course there may be some C6H12O6 which I don't know about, it may be even more ambiguous that 145 possible meanings suggests).

    My brain hurts now

  • July 24, 2012 at 6:27 pm

    #1517132

    Lynn Pettis (7/24/2012)

    And what pray tell are these in laymans terms?

    I though that was in laymans terms - after all, I was a mathematician, not a chemist, and mathematicians are laymen in chemistry, and I sort of understand it (I think; I may well have it all wrong).

    In simpler terms, the 136 (or so) hexoses are sugar, and the 9 inositols are alcohols (6 fold polyols of cyclohexane, to be more precise).

    But the real point is that Jason's "C6H12O6" doesn't count as a word because no word in the world is that ambiguous (although hexose comes close).

    edit: Many of these compounds are essential to human life (but we can synthesize most or maybe all of those in our bodies, so none of them count as vitamins, although some used to because we didn't know enough).

    Tom

  • July 25, 2012 at 9:19 am

    #1517425

    L' Eomot Inversé (7/24/2012)

    Lynn Pettis (7/24/2012)

    And what pray tell are these in laymans terms?

    I though that was in laymans terms - after all, I was a mathematician, not a chemist, and mathematicians are laymen in chemistry, and I sort of understand it (I think; I may well have it all wrong).

    In simpler terms, the 136 (or so) hexoses are sugar, and the 9 inositols are alcohols (6 fold polyols of cyclohexane, to be more precise).

    But the real point is that Jason's "C6H12O6" doesn't count as a word because no word in the world is that ambiguous (although hexose comes close).

    edit: Many of these compounds are essential to human life (but we can synthesize most or maybe all of those in our bodies, so none of them count as vitamins, although some used to because we didn't know enough).

    Sugar, inositol and alcohol

    essential to human life

  • July 25, 2012 at 11:50 pm

    #1517739

    Daniel Bowlin (7/25/2012)

    L' Eomot Inversé (7/24/2012)

    Lynn Pettis (7/24/2012)

    And what pray tell are these in laymans terms?

    I though that was in laymans terms - after all, I was a mathematician, not a chemist, and mathematicians are laymen in chemistry, and I sort of understand it (I think; I may well have it all wrong).

    In simpler terms, the 136 (or so) hexoses are sugar, and the 9 inositols are alcohols (6 fold polyols of cyclohexane, to be more precise).

    But the real point is that Jason's "C6H12O6" doesn't count as a word because no word in the world is that ambiguous (although hexose comes close).

    edit: Many of these compounds are essential to human life (but we can synthesize most or maybe all of those in our bodies, so none of them count as vitamins, although some used to because we didn't know enough).

    Sugar, inositol and alcohol

    essential to human life

    Carbohydrate.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
     🙂

  • July 26, 2012 at 7:12 am

    #1517912

    Begin

  • July 26, 2012 at 7:13 am

    #1517916

    Daniel Bowlin (7/26/2012)

    Begin

    TRY

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 26, 2012 at 8:10 am

    #1517959

    L' Eomot Inversé (7/23/2012)

    ChrisM@Work (7/23/2012)

    SQLRNNR (7/23/2012)

    C6H12O6

    6-(hydroxymethyl)oxane-2,3,4,5-tetrol

    Jason's C6H12O6 is a nasty ambiguous formula. ChrisW's thing is less ambiguous (but still ambiguous).

    There's a nasty ambiguous word for it: hexose; but it's not quite as ambiguous as the formula.

    It's 40 years since I studied any chemistry, and I haven't used any of it since 1970, but I reckon that there are hordes (at least 136) of different compounds called hexose, some (at least 60) of which occur naturally, some others we can manufacture, and yet others of which neither occur naturally (at least on earth) nor have we manufactured them yet (as far as I know). In addition there are 9 different inositols (CHOH)6. So that's at least 145 things which are each C6H12O6.

    16 straight-chain aldohexoses H(CHOH)5CHO (7 naturally occurring ones, and another 9 theoretically possible ones). These are short-lived transient forms, which occur when one of the ring form hexopyranoses temporarily opens out before reforming into a different ring form (which might not be a hexopyranose).

    32 Hexopyranoses - ring forms with topology O(CHOH)4CH2.CHOH, 2 related to each of the above aldohexoses (14 naturally occurring, 2 of which are - I think - used as [the main ingredient of] table sugar, and 18 others are theoretically possible). a-D-Glucopyranose and ß-D-Glucopyranose are the two forms in table sugar, I think, but I could have that wrong. But these 32 are really 96, because each of the 32 comes as 3 torsion/rotation isomers.

    I think ChrisM's "6-(hydroxymethyl)oxane-2,3,4,5-tetrol" is probably generally used for any of the dextrorotatory D-hexopyranoses (not all D-hexopyranoses are dextrorotatory, despite the D- prefix) although it looks as if it ought to apply to all 32 hexopyranoses, but maybe it's some other sbset of them.

    16 Hexofuranoses – ring forms with topology OCHCH2OH(CHOH)3COH.CH2OH, derived from the straight aldohoses, of which 7 do occur naturally but never in solid form. Or are there 32, not 16?

    8 ketohexoses CH2OH(CHOH)3COCH2OH of which 4 occur naturally. These are formed as transients when a Hexofuranose temporarity opens out, before forming a new ring (which may not be a hexofuranose).

    Inositol, an alcohol formed by a ring of 6 CHOH groups, has 5 naturally occurring forms; there are 4 other possible forms.

    Maybe there are some more forms of C6H12O6 – I'm no expert.

    But there's no word that I believe is exactly as ambiguous as Jason's formula: C6H12O6. The nearest is "hexose", which has only 136 different meanings (as far as I know), and C6H12O6 represents 145 different things (of course there may be some C6H12O6 which I don't know about, it may be even more ambiguous that 145 possible meanings suggests).

    Tom, carbohydrate chemistry is a massive and important field of study which we barely touched on when I did my bichemistry degree in Aberdeen in the 70's, nevertheless I'm familiar with the names and can even remember one or two of the structures which you mention - but how on earth do you remember all of this when it wasn't even your major?

    Extraordinary. You're a walking wiki.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • July 26, 2012 at 9:30 am

    #1518024

    opc.three (7/26/2012)

    Daniel Bowlin (7/26/2012)

    Begin

    TRY

    No. DO. Or do not. There is no "try."

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • July 26, 2012 at 10:08 am

    #1518044

    Ray K (7/26/2012)

    opc.three (7/26/2012)

    Daniel Bowlin (7/26/2012)

    Begin

    TRY

    No. DO. Or do not. There is no "try."

    Yoda

Viewing 15 posts - 6,856 through 6,870 (of 21,190 total)

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