Are the posted questions getting worse?

  • Alvin Ramard (5/27/2009)


    Bob Hovious (5/27/2009)


    What's an index?

    It's one of your fingers.

    No, not that one!! the one next to it!! Jeesh . .. :hehe:

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • GilaMonster (5/28/2009)


    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Wow!

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • Roy Ernest (5/28/2009)


    I liked the thread about the table Status.... πŸ˜€

    Both of them are about that same table. I liked it when the guy said the table was part of SSMS.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Tom Brown (5/27/2009)


    Gaby Abed (5/27/2009)


    Jack Corbett (5/27/2009)

    Discussing this, just in jest will get the thread to 5000 posts pretty quickly.

    Hmmm...a challenge? Who will be the 5000th post?

    Will there be a prize? πŸ˜€

    The lucky 5000th will be granted authorship of the index book πŸ˜€

    Thank God I missed catching up with you guys till after you passed the mark πŸ˜‰

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Bob Hovious (5/28/2009)


    Nope that would only add excitement to baseball if you were allowed to clock the 1st baseman in the ribs to make him drop the ball as he was catching it.

    Of course if that was the case you'd probably need to carry more fielders than pitchers for the first time in a long time. You know every so often someone would take a bat to the back of the head. Ouch.

    So we armor up the guys in the infield with flak jackets, pads and helmets, and then let them physically block the runners from touching the bases......

    This is promising $!$!$ πŸ˜€

    Basebrawl. Mad Magazine had an article about it in the '70s. Was entertaining then too.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Gaby Abed (5/28/2009)


    GilaMonster (5/28/2009)


    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Wow!

    Reminds me of the Four Candles sketch by the Two Ronnies

    http://www.youtube.com/watch?v=qu9MptWyCB8

  • Limited precognition is actually one of my mutant powers, Gail. Having looked at that thread I had a sudden glimpse of the future that told me I would NOT be trying to help that OP. πŸ˜‰

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • Paul White (5/27/2009)


    Right then.

    Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?

    We could all get fabulously rich!!! :w00t:

    Paul

    There's gonna be a queue behind you on this one, Paul. Wait a minute..."W"...you're gonna be somewhere near the end.

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

  • Bob Hovious (5/28/2009)


    Limited precognition is actually one of my mutant powers, Gail. Having looked at that thread I had a sudden glimpse of the future that told me I would NOT be trying to help that OP. πŸ˜‰

    πŸ˜€ :hehe:

    I believe I'm going to exercise the greater part of valour, and make a strategic retreat from both of those threads.

    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
  • GilaMonster (5/28/2009)


    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Gail, how are you lucky enough to find all these wonderful folks???

    -- You can't be late until you show up.

  • GilaMonster (5/28/2009)


    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster, but being the curious type, I did try to find some way to get 12:16pm with 56 secs from 1243012622. No luck, but an interesting thing:

    12:16:56 = 44216000 milliseconds since prior midnight

    1243012622 / 44216000 = 28112.28112

    Spooky.

  • Dave Smith (5/28/2009)


    GilaMonster (5/28/2009)


    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster, but being the curious type, I did try to find some way to get 12:16pm with 56 secs from 1243012622. No luck, but an interesting thing:

    12:16:56 = 44216000 milliseconds since prior midnight

    1243012622 / 44216000 = 28112.28112

    Spooky.

    he might have made a mistake ....

    60*0.43=25.8

    12:26 sounds mire reasonable, that assuming I know what's going on.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • jcrawf02 (5/28/2009)


    Tom Brown (5/27/2009)


    Lynn Pettis (5/26/2009)


    OMG, you really have to be kidding here...

    As a complete and totally unrelated aside: -

    There's a character called Trigger in the BBC comedy Only Fools 'n' Horses http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml

    Why 'Trigger' - I always thought it was because he was sooo intellectually quick witted.

    Trigger was Roy Rogers' horse, that was my first thought on seeing the title of the show.

    According to Wikipedia, the character in Only Fools 'n' Horses was named Trigger because he apparently looked like a horse. Can't judge that one as I haven't seen the show, but that's what Wikipedia says (and we ALL know that Wikipedia is NEVER wrong... most of the time...)

    -- Kit

  • tosscrosby (5/28/2009)


    GilaMonster (5/28/2009)


    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Gail, how are you lucky enough to find all these wonderful folks???

    Steve, quote button no worky, I was trying to quote this:

    GilaMonster (5/28/2009)

    --------------------------------------------------------------------------------

    I thought I'd seen everything....

    Anyone (preferably someone who's telepathic or precog) want to tackle these?

    http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx

    http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx

    Unfortunately, sunspot activity is currently inhibiting my psionic abilities, so I can't help the poster, but being the curious type, I did try to find some way to get 12:16pm with 56 secs from 1243012622. No luck, but an interesting thing:

    12:16:56 = 44216000 milliseconds since prior midnight

    1243012622 / 44216000 = 28112.28112

    Spooky.

    which, it appears, might maybe be helpful.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Kit G (5/28/2009)


    jcrawf02 (5/28/2009)


    Tom Brown (5/27/2009)


    Lynn Pettis (5/26/2009)


    OMG, you really have to be kidding here...

    As a complete and totally unrelated aside: -

    There's a character called Trigger in the BBC comedy Only Fools 'n' Horses http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml

    Why 'Trigger' - I always thought it was because he was sooo intellectually quick witted.

    Trigger was Roy Rogers' horse, that was my first thought on seeing the title of the show.

    According to Wikipedia, the character in Only Fools 'n' Horses was named Trigger because he apparently looked like a horse. Can't judge that one as I haven't seen the show, but that's what Wikipedia says (and we ALL know that Wikipedia is NEVER wrong... most of the time...)

    Wikifrickintastic! That childhood cooped up in the house and tortured with Singing Sandy, Roy Rogers and the Sons of the Pioneers finally pays off. Jackpot!!!

    it's all downhill from here . . .

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 5,086 through 5,100 (of 66,738 total)

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