Are the posted questions getting worse?

  • Sean Lange (8/10/2015)


    SQLRNNR (8/10/2015)


    Sean Lange (8/10/2015)


    kwere

    The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

    kwire

    The above sounds like "clear" or "fear"? This is who I pronounce and nearly everyone I know and have met.

    kwรดre

    The above sounds like "core" or "bore"? I have never heard it pronounced like that.

    Interesting on the first one, it should not sound like air or fair. It is more like a soft e sound than an a sound. And this is the style I hear 90% of the time.

    The leer jet query is really harsh on the ears. You might say it is leery.

    We may need to have sound bites posted in order to solve this debate. Of course be "fear"ful of my "beer"y way of saying query, it may sound too to "eerie" for you. ๐Ÿ˜›

    It's pronounced "magic fairy dust" around these parts ๐Ÿ™‚

    Rodders...

  • rodjkidd (8/11/2015)


    Sean Lange (8/10/2015)


    SQLRNNR (8/10/2015)


    Sean Lange (8/10/2015)


    kwere

    The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

    kwire

    The above sounds like "clear" or "fear"? This is who I pronounce and nearly everyone I know and have met.

    kwรดre

    The above sounds like "core" or "bore"? I have never heard it pronounced like that.

    Interesting on the first one, it should not sound like air or fair. It is more like a soft e sound than an a sound. And this is the style I hear 90% of the time.

    The leer jet query is really harsh on the ears. You might say it is leery.

    We may need to have sound bites posted in order to solve this debate. Of course be "fear"ful of my "beer"y way of saying query, it may sound too to "eerie" for you. ๐Ÿ˜›

    It's pronounced "magic fairy dust" around these parts ๐Ÿ™‚

    Rodders...

    That's the stuff sprinkled onto footballers on the field by medics. After five minutes writhing on the ground clutching one shin or the other (sometimes inexplicably switching) and gurning like a good 'un, they suddenly leap into the air as if recharged. Magic Fairy Dust. Found at all Dances of the Prancing Lawn Fairies. Did I just say that? I meant football matches.

    โ€œ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

  • ChrisM@Work (8/11/2015)


    rodjkidd (8/11/2015)


    Sean Lange (8/10/2015)


    SQLRNNR (8/10/2015)


    Sean Lange (8/10/2015)


    kwere

    The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

    kwire

    The above sounds like "clear" or "fear"? This is who I pronounce and nearly everyone I know and have met.

    kwรดre

    The above sounds like "core" or "bore"? I have never heard it pronounced like that.

    Interesting on the first one, it should not sound like air or fair. It is more like a soft e sound than an a sound. And this is the style I hear 90% of the time.

    The leer jet query is really harsh on the ears. You might say it is leery.

    We may need to have sound bites posted in order to solve this debate. Of course be "fear"ful of my "beer"y way of saying query, it may sound too to "eerie" for you. ๐Ÿ˜›

    It's pronounced "magic fairy dust" around these parts ๐Ÿ™‚

    Rodders...

    That's the stuff sprinkled onto footballers on the field by medics. After five minutes writhing on the ground clutching one shin or the other (sometimes inexplicably switching) and gurning like a good 'un, they suddenly leap into the air as if recharged. Magic Fairy Dust. Found at all Dances of the Prancing Lawn Fairies. Did I just say that? I meant football matches.

    You mean something like this?

    Seems like a very serious injury...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (8/11/2015)


    ChrisM@Work (8/11/2015)


    rodjkidd (8/11/2015)


    Sean Lange (8/10/2015)


    SQLRNNR (8/10/2015)


    Sean Lange (8/10/2015)


    kwere

    The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

    kwire

    The above sounds like "clear" or "fear"? This is who I pronounce and nearly everyone I know and have met.

    kwรดre

    The above sounds like "core" or "bore"? I have never heard it pronounced like that.

    Interesting on the first one, it should not sound like air or fair. It is more like a soft e sound than an a sound. And this is the style I hear 90% of the time.

    The leer jet query is really harsh on the ears. You might say it is leery.

    We may need to have sound bites posted in order to solve this debate. Of course be "fear"ful of my "beer"y way of saying query, it may sound too to "eerie" for you. ๐Ÿ˜›

    It's pronounced "magic fairy dust" around these parts ๐Ÿ™‚

    Rodders...

    That's the stuff sprinkled onto footballers on the field by medics. After five minutes writhing on the ground clutching one shin or the other (sometimes inexplicably switching) and gurning like a good 'un, they suddenly leap into the air as if recharged. Magic Fairy Dust. Found at all Dances of the Prancing Lawn Fairies. Did I just say that? I meant football matches.

    You mean something like this?

    Seems like a very serious injury...

    That's him! Very talented actor, not afraid to get down and dirty.

    โ€œ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

  • ChrisM@Work (8/11/2015)


    Koen Verbeeck (8/11/2015)


    You mean something like this?

    Seems like a very serious injury...

    That's him! Very talented actor, not afraid to get down and dirty.

    And despite his successes, he has always stayed grounded.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (8/11/2015)


    ChrisM@Work (8/11/2015)


    Koen Verbeeck (8/11/2015)


    You mean something like this?

    Seems like a very serious injury...

    That's him! Very talented actor, not afraid to get down and dirty.

    And despite his successes, he has always stayed grounded.

    Dedication to the "game"

    ๐Ÿ˜Ž

  • Alvin Ramard (8/10/2015)


    Jack Corbett (8/10/2015)


    Steve Jones - SSC Editor (8/10/2015)


    Query query, sql sql, should we debate tomatoes and potatoes as well?

    How about "daytah" vs. "dahtah"?

    OMG. That was on a TNG rerun this weekend. ๐Ÿ™‚

    Heh - I remember that one. That was Dr. Pulaski talking to Data. I don't remember the name of the episode, but I think it was the first one where she appeared. I liked Dr. Crusher's character better.

  • ChrisM@Work (8/11/2015)


    rodjkidd (8/11/2015)


    Sean Lange (8/10/2015)


    SQLRNNR (8/10/2015)


    Sean Lange (8/10/2015)


    kwere

    The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

    kwire

    The above sounds like "clear" or "fear"? This is who I pronounce and nearly everyone I know and have met.

    kwรดre

    The above sounds like "core" or "bore"? I have never heard it pronounced like that.

    Interesting on the first one, it should not sound like air or fair. It is more like a soft e sound than an a sound. And this is the style I hear 90% of the time.

    The leer jet query is really harsh on the ears. You might say it is leery.

    We may need to have sound bites posted in order to solve this debate. Of course be "fear"ful of my "beer"y way of saying query, it may sound too to "eerie" for you. ๐Ÿ˜›

    It's pronounced "magic fairy dust" around these parts ๐Ÿ™‚

    Rodders...

    That's the stuff sprinkled onto footballers on the field by medics. After five minutes writhing on the ground clutching one shin or the other (sometimes inexplicably switching) and gurning like a good 'un, they suddenly leap into the air as if recharged. Magic Fairy Dust. Found at all Dances of the Prancing Lawn Fairies. Did I just say that? I meant football matches.

    Not knowing much about football, do the players have to take acting lessons? ๐Ÿ˜€

  • djj (8/11/2015)


    ChrisM@Work (8/11/2015)


    rodjkidd (8/11/2015)


    Sean Lange (8/10/2015)


    SQLRNNR (8/10/2015)


    Sean Lange (8/10/2015)


    kwere

    The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

    kwire

    The above sounds like "clear" or "fear"? This is who I pronounce and nearly everyone I know and have met.

    kwรดre

    The above sounds like "core" or "bore"? I have never heard it pronounced like that.

    Interesting on the first one, it should not sound like air or fair. It is more like a soft e sound than an a sound. And this is the style I hear 90% of the time.

    The leer jet query is really harsh on the ears. You might say it is leery.

    We may need to have sound bites posted in order to solve this debate. Of course be "fear"ful of my "beer"y way of saying query, it may sound too to "eerie" for you. ๐Ÿ˜›

    It's pronounced "magic fairy dust" around these parts ๐Ÿ™‚

    Rodders...

    That's the stuff sprinkled onto footballers on the field by medics. After five minutes writhing on the ground clutching one shin or the other (sometimes inexplicably switching) and gurning like a good 'un, they suddenly leap into the air as if recharged. Magic Fairy Dust. Found at all Dances of the Prancing Lawn Fairies. Did I just say that? I meant football matches.

    Not knowing much about football, do the players have to take acting lessons? ๐Ÿ˜€

    Well, obviously the ones who switch from holding one leg to holding the other when in fact it was a grasping hand clinging onto their shirt which brought them down. Some of them are naturals.

    โ€œ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

  • Koen Verbeeck (8/11/2015)


    That's the stuff sprinkled onto footballers on the field by medics. After five minutes writhing on the ground clutching one shin or the other (sometimes inexplicably switching) and gurning like a good 'un, they suddenly leap into the air as if recharged. Magic Fairy Dust. Found at all Dances of the Prancing Lawn Fairies. Did I just say that? I meant football matches.

    You mean something like this?

    Seems like a very serious injury...

    Geez, did he get shot in the back with a bean bag round or something?

  • Only 10 posts to go...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (8/11/2015)


    Only 10 posts to go...

    and you're reached the corner of the field.

    โ€œ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

  • Koen Verbeeck (8/11/2015)


    Only 10 posts to go...

    Correction, only 7 posts to go...:-D

    ๐Ÿ˜Ž

  • We've reached page 5000 on the standard layout, so only a couple of more to cross the 50,000 post line. Is anyone going to just post them all to make it happen?

    Oh, and I was going to use a bad word to describe this person, but let's just get it done.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Grant Fritchey (8/11/2015)


    We've reached page 5000 on the standard layout, so only a couple of more to cross the 50,000 post line. Is anyone going to just post them all to make it happen?

    I'm certain that can be achieved. The query I'm trying to tune takes 7 min per execution, so I have time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 15 posts - 49,981 through 49,995 (of 66,712 total)

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