Are the posted questions getting worse?

  • Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Yay - party at Steve's place!!!

    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

  • SQLRNNR (12/19/2014)


    Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Yay - party at Steve's place!!!

    Dogs and barn help still here.

    May or may not be armed.

  • Steve Jones - SSC Editor (12/19/2014)


    SQLRNNR (12/19/2014)


    Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Yay - party at Steve's place!!!

    Dogs and barn help still here.

    May or may not be armed.

    They're invited to the party as well!

  • Lynn Pettis (12/19/2014)


    Steve Jones - SSC Editor (12/19/2014)


    SQLRNNR (12/19/2014)


    Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Yay - party at Steve's place!!!

    Dogs and barn help still here.

    May or may not be armed.

    They're invited to the party as well!

    Whether they have arms or not.

    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

  • Do you all have fun and/or hectic holiday plans still to come? My wife and I are finished with our holidays this year, Thanksgiving being the last big one, and are looking forward to rest and relaxation at last. Only event coming up is a casual New Year's party and brunch with friends and feeding a friend's cats while they're away for XMass.

    --------------------------------------
    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

  • Having transitioned back to nights, I will be posting my count down at the end of my shift:

    ... Mark one off, 70 days on the calendar to go. 70 days on the calendar to go, 70 days to go, ...

  • GilaMonster (12/19/2014)


    jasona.work (12/19/2014)


    (I think some of the L2 and L1 cache, various other bits and bobs)

    Each core has it's own L1, at least with the Intel processors. L2 is 'shared' (kinda, one core can't flush the entire of L2), L3 if present as well.

    Reason multiple cores is better than multiple processors is to do with the inter-core communication. With them really close together, there's less delay in communications between them.

    I don't think there are any non-intel multi-core processors with shared L1 cache; if there are, they will have poor performance compared to those that don't do that.

    There are other reasons multiple processors are not as good as multiple cores: for example a 4 core processr doesn't require as many lines onto the motherboard as 4 1-core processors, and that is quite a useful space saving (and, I believe, the main original motivaton for multi-core CPUs - I could be wrong on that, but I think Brandy was right). Core to core communication is the biggest performance factor, but maybe not the biggest performance per unit cost factor (I don't know). But there are both roundabouts and swings here - cooling issues are the other side of the coin.

    Tom

  • Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    And the same to you.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Your missing an adverb - I'll be doing exactly as you say, I'll cetainly behave. But that doesnt constrain how I behave, does it?

    Tom

  • ... Mark one off, 69 days on the calendar to go. 69 days on the calendar to go, 69 days to go, ...

  • Steve Jones - SSC Editor (12/19/2014)


    SQLRNNR (12/19/2014)


    Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Yay - party at Steve's place!!!

    Dogs and barn help still here.

    May or may not be armed.

    Heh... no problem. Bones'n'Booze is standard carry for such parties. ๐Ÿ˜€

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • ... Mark one off, 68 days on the calendar to go. 68 days on the calendar to go, 68 days to go, ...

  • Steve Jones - SSC Editor (12/19/2014)


    SQLRNNR (12/19/2014)


    Steve Jones - SSC Editor (12/19/2014)


    Merry Christmas and Happy Holidays, everyone.

    I'll be gone after tomorrow, heading away for a week. Everyone behave.

    Yay - party at Steve's place!!!

    Dogs and barn help still here.

    May or may not be armed.

    Your dogs want steak...

    ๐Ÿ™‚

    I would expect the barn help to be armed, after all, it's kind of difficult using a pitchfork with no arms...

  • Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx

    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 (12/22/2014)


    Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx

    OMG!

    Cannot be unseen......:sick:

    -- Gianluca Sartori


  • Brandie Tarvin (12/16/2014)


    But still... To my mind, since I'm already fixing one part of the package, why shouldn't I proactively fix the rest of it to make sure the other 6 procs and ETL paths do NOT become a problem down the road?

    Or am I just being too efficient?

    I'm in your corner, Brandie. In my experience opportunities to pay down technical debt through refactoring can be so difficult to come by (getting approval for them, finding time for them, etc.) that when the window is open you should try to cram as much through as possible. I suppose one consideration might be the scope of the testing required before the changes can be released into production, but if the code is passing all tests why not release it?

Viewing 15 posts - 46,681 through 46,695 (of 66,738 total)

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