Are the posted questions getting worse?

  • Grant Fritchey (7/23/2010)


    Ray K (7/22/2010)


    Uh oh, bad blood starting to break out here . . .

    Nah, the guy's taking a beating for something he didn't create. I know the feeling all too well. He might be starting to overreact but I think he took a few unnecessary shots.

    Yeah, I actually sympathize with him. I know what it's like to inherit bad legacy code (as I'm sure a lot of people here do). Poor guy.

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

  • Roy Ernest (7/23/2010)


    Grant Fritchey (7/23/2010)


    Ray K (7/22/2010)


    Uh oh, bad blood starting to break out here . . .

    Nah, the guy's taking a beating for something he didn't create. I know the feeling all too well. He might be starting to overreact but I think he took a few unnecessary shots.

    I did not post there since I was not sure what I was going to post would be stupid or not. The OP states that when he changed to temp table, it ran faster and then it bogged down again. For me that feels like he has quite a bit of memory pressure and is doing loads of paging. His output is over 30 million rows. That would also mean that he is going to have lots of IO bottle neck. You can do as much tuning on that but that stored proc will always have problem if it has to out put that much rows.

    Am I being stupid or am I correct?

    You're pretty on. There are LOTS of issues going on there. But the guy is dealing with them as best he can. For some reason the thread just got a bit ugly. Not sure why.

    "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

  • Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a new position is started.

    Scared, nervous, anxious. :w00t:

  • I think the thread went a little sideways since the same advice was thrown out there. Get help. I can understand that is a little overwhelming. For people that don't post a lot, they feel they need to respond and deal with every post, which makes most people defensive. It looks like it slowed down. If it flares up, I'll send a "calming" note to the OP

  • ItsYourTurn has a dark chess variant - you can only see the squares your pieces can directly attack. They never see your knight coming, but he kind of wanders around not knowing who is coming after him either. πŸ˜›

    Chad

    I used to have a membership at ItsYourTurn and have played Dark Chess, Atomic Chess, and the truly challenging Game of The Amazons, which is a fascinating hybrid of Go and Chess.

    __________________________________________________

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

  • Kaclick khazad!! Khazad ai-menu!!

    (Keyboards of the dwarves! The dwarves are upon you!)

    http://www.dadhacker.com/blog/?p=561

    __________________________________________________

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

  • Lynn Pettis (7/23/2010)


    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a new position is started.

    Scared, nervous, anxious. :w00t:

    Congrats and good luck. It feels good to move on to a new gig from time to time.

    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

  • Lynn Pettis (7/23/2010)


    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a new position is started.

    Scared, nervous, anxious. :w00t:

    Congratulations. May your new position be challenging, interesting and rewarding.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • Lynn Pettis (7/23/2010)


    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a new position is started.

    Scared, nervous, anxious. :w00t:

    Congrats on the new gig. Seems like a lot of people I know are changing jobs. I'm bound to where I am until next July. Not sure what I'll be doing after that. I could stay or I could move on.

  • Stefan Krzywicki (7/23/2010)


    Lynn Pettis (7/23/2010)


    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a new position is started.

    Scared, nervous, anxious. :w00t:

    Congratulations. May your new position be challenging, interesting and rewarding.

    I'm sure it will be. :w00t:

  • Lynn Pettis (7/23/2010)


    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a new position is started.

    Scared, nervous, anxious. :w00t:

    Good luck Lynn. You don't need it. You'll be great.

    "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

  • Break a leg, Lynn.

    __________________________________________________

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

  • Congrats, Lynn. All the best.

    -- Gianluca Sartori

  • The Dixie Flatline (7/23/2010)


    Break a leg, Lynn.

    Uh, NO! Broke an ankle back in 2000, NOT FUN! πŸ˜›

    Thanks! All the good thoughts are needed with this move. :w00t:

  • The Dixie Flatline (7/23/2010)


    Break a leg, Lynn.

    hmmm, you didn't say who's leg, or what kind of leg, to break. Leg from the kitchen table? πŸ˜›

    Congratulations Lynn and I hope it all goes well.



    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]

Viewing 15 posts - 16,681 through 16,695 (of 66,712 total)

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