December 19, 2014 at 11:57 am
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
December 19, 2014 at 11:58 am
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.
December 19, 2014 at 12:04 pm
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!
December 19, 2014 at 1:13 pm
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
December 19, 2014 at 1:29 pm
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
December 19, 2014 at 7:24 pm
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, ...
December 20, 2014 at 4:14 pm
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
December 20, 2014 at 4:23 pm
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
December 20, 2014 at 9:12 pm
... Mark one off, 69 days on the calendar to go. 69 days on the calendar to go, 69 days to go, ...
December 21, 2014 at 1:21 pm
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
Change is inevitable... Change for the better is not.
December 21, 2014 at 7:05 pm
... Mark one off, 68 days on the calendar to go. 68 days on the calendar to go, 68 days to go, ...
December 22, 2014 at 8:57 am
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...
December 22, 2014 at 9:26 am
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
December 22, 2014 at 9:47 am
GilaMonster (12/22/2014)
Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx
OMG!
Cannot be unseen......:sick:
-- Gianluca Sartori
December 22, 2014 at 9:50 am
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,712 total)
You must be logged in to reply to this topic. Login to reply