December 7, 2016 at 7:21 am
December 7, 2016 at 8:16 am
In Orlando this week for Live360. Leaving this afternoon, and it's 18F at home. Didn't bring a coat, and couldn't wear a long sleeve this morning since it's a 80F mile walk from the hotel to the convention center.
At least I have a hat for the trip to my car in Denver.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 7, 2016 at 8:44 am
Steve Jones - SSC Editor (12/7/2016)
In Orlando this week for Live360. Leaving this afternoon, and it's 18F at home. Didn't bring a coat, and couldn't wear a long sleeve this morning since it's a 80F mile walk from the hotel to the convention center.At least I have a hat for the trip to my car in Denver.
Who cares if the extremities freeze off? At least the top of the head is covered.
Hope you have someone meeting you at the airport with a coat.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
December 7, 2016 at 11:25 am
Jeff Moden (12/7/2016)
...Here's to you, Dwain. May your work and our memories of you last forever. You were a great man and a thoughtful and humble human...
For many years I've considered myself a student of people like you and Dwain, and I'm sure his works will continue to inspire and teach many people for years to come.
December 8, 2016 at 3:32 am
rodjkidd (12/7/2016)
Eirikur,I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?
Chris, are you about?
Rodders...
Oh poo. Sorry I missed it - didn't get home until midday yesterday.
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
December 8, 2016 at 3:39 am
Jeff Moden (12/7/2016)
This Saturday, 12/10, marks the anniversary of a very unhappy event for me. It's the day that Dwain Camps fell to cancer. Dwain was a remarkable author and, although I never had the pleasure of meeting him in person, was an incredible long distance friend that I conversed with often. He had an incredible mind. He went from being a virtual neophyte at T-SQL to being a world recognized SQL Ninja virtually overnight.Here's to you, Dwain. May your work and our memories of you last forever. You were a great man and a thoughtful and humble human. I miss you terribly. I hope there are fish at least as big as the one in your avatar where you're at now.
Dwain Camps - one of a kind, taken from us too soon.
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
December 8, 2016 at 8:59 am
<Contented sigh>Two weeks ago I ran a load test comparing SQL Server 2014 and 2016 with a real load from our production systems. 2016 ran 50% slower than 2014 on the same hardware. I went through all the configuration settings to make sure everything was setup the same and that all the new performance improvements in 2016 were turned on. Nothing helped. After playing with every setting I could think of that might make a difference, profiling queries to look for regressing plans, and digging through all the metrics and logging I could find, I finally nailed it I think. SQL 2016 and Windows were fighting over RAM. Every time Windows set the "low memory" flag, the plan cache took the brunt of the reduction in memory resulting in a spike in CPU overhead as plans were rebuilt.
Just had to share with the watercooler, it's lifted a burden that's hung over me for the last 2 weeks and I'm on a high now. Party at the TITD tonight! π
Chad
December 8, 2016 at 10:00 am
Doing some code cleanup today, running into lots of this
insert into <someTable>
select <a bunch of stuff>
from <SomeOtherTable>
where <some column> is not null
order by 2, 1;
I guess you can't just go inserting data in any ol' order.
-- Itzik Ben-Gan 2001
December 8, 2016 at 10:09 am
Jeff Moden (12/7/2016)
This Saturday, 12/10, marks the anniversary of a very unhappy event for me...
Ditto.
-- Itzik Ben-Gan 2001
December 8, 2016 at 10:24 am
Alan.B (12/8/2016)
Jeff Moden (12/7/2016)
This Saturday, 12/10, marks the anniversary of a very unhappy event for me...Ditto.
I can't help feeling sad when I remember this. I never met him in person either, but he was certainly one of the greats.
December 8, 2016 at 2:12 pm
RIP, Mr Camps from last year,
RIP, Mr Glenn, today
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 9, 2016 at 12:44 am
Chris Harshman (12/7/2016)
Jeff Moden (12/7/2016)
...Here's to you, Dwain. May your work and our memories of you last forever. You were a great man and a thoughtful and humble human...For many years I've considered myself a student of people like you and Dwain, and I'm sure his works will continue to inspire and teach many people for years to come.
Seconded.
It's been a crap 12 months for losing people I've admired or known.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. β Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
December 9, 2016 at 4:20 am
ChrisM@Work (12/8/2016)
rodjkidd (12/7/2016)
Eirikur,I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?
Chris, are you about?
Rodders...
Oh poo. Sorry I missed it - didn't get home until midday yesterday.
And i've only just caught up with this... Oops
Next time Chris!
Rodders...
December 9, 2016 at 7:42 am
rodjkidd (12/9/2016)
ChrisM@Work (12/8/2016)
rodjkidd (12/7/2016)
Eirikur,I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?
Chris, are you about?
Rodders...
Oh poo. Sorry I missed it - didn't get home until midday yesterday.
And i've only just caught up with this... Oops
Next time Chris!
Rodders...
You guys need to exchange phone numbers. Text messages have far quicker notifications than The Thread. @=)
December 9, 2016 at 7:51 am
Brandie Tarvin (12/9/2016)
rodjkidd (12/9/2016)
ChrisM@Work (12/8/2016)
rodjkidd (12/7/2016)
Eirikur,I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?
Chris, are you about?
Rodders...
Oh poo. Sorry I missed it - didn't get home until midday yesterday.
And i've only just caught up with this... Oops
Next time Chris!
Rodders...
You guys need to exchange phone numbers. Text messages have far quicker notifications than The Thread. @=)
Oh Brandie that would be far too sensible!
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
Viewing 15 posts - 56,866 through 56,880 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply