October 13, 2016 at 1:11 pm
Sean Lange (10/13/2016)
Lynn Pettis (10/13/2016)
I am really getting tired of Mr. Celko. And obviously he is losing it as he can't seem to type English sentences without stammering.No kidding. I get the gist of his post but the actual words written are rubbish. They sentences are so completely mangled as to make his whole post uesless.
I love my career, I love the company where I work, but between Mr. Celko and the new breed of entitled worker I am starting to think about retirement. Granted I have about ten years or so before full retirement age, but not sure I will make it and still be at least some what sane.
I have started looking at ex-pat retirement looking at places like Costa Rica, Ecuador, Thailand, Ireland. So far those places look like affordable locations should Social Security still be around.
October 13, 2016 at 1:20 pm
Sean Lange (10/13/2016)
Lynn Pettis (10/13/2016)
I am really getting tired of Mr. Celko. And obviously he is losing it as he can't seem to type English sentences without stammering.No kidding. I get the gist of his post but the actual words written are rubbish. They sentences are so completely mangled as to make his whole post uesless.
Compared to his usual more erudite posts, the one in question almost reads like his account was hacked by someone whose first language isn't English and tis posting from a smart phone...
Not to excuse the attitude in the post, but geez...
October 13, 2016 at 3:32 pm
jasona.work (10/13/2016)
Sean Lange (10/13/2016)
Lynn Pettis (10/13/2016)
I am really getting tired of Mr. Celko. And obviously he is losing it as he can't seem to type English sentences without stammering.No kidding. I get the gist of his post but the actual words written are rubbish. They sentences are so completely mangled as to make his whole post uesless.
Compared to his usual more erudite posts, the one in question almost reads like his account was hacked by someone whose first language isn't English and tis posting from a smart phone...
Not to excuse the attitude in the post, but geez...
Jason, you may be on to something here. The last post from Mr. Celko I read doesn't sound quite like him either. Still, if it is him, I just wish he would go away.
October 13, 2016 at 4:22 pm
Wow, what an answer to a 2 year old thread. No idea where they came up with that idea.
October 14, 2016 at 6:15 am
Sean Lange (10/13/2016)
Brandie Tarvin (10/13/2016)
ChrisM@Work (10/13/2016)
Brandie Tarvin (10/13/2016)
GilaMonster (10/13/2016)
Grant Fritchey (10/13/2016)
Sean Lange (10/13/2016)
WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.htmlThis is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or explanation. And some of them are just plain awful. :sick:
What?
"Use EXISTS instead of DISTINCT when using joins which involves tables having one-to-many relationship."
I can kinda see where that one comes from (though it's badly articulated). Consider:
SELECT DISTINCT CustomerName FROM Customers INNER JOIN Orders ON ... WHERE OrderStatus = 'A'
vs
SELECT CustomerName FROM Customers WHERE EXISTS (SELECT 1 FROM Orders WHERE <join> and OrderStatus = 'A')
The latter is likely to be more efficient than the former.
Okay, so it's time to learn something new here... Can you point me to a reference (because I don't want to bog down The Thread on technicalities) so I can read up on why EXISTS might be more efficient than the JOIN?
Gail's published tons of work comparing IN/EXISTS etc. subqueries on her blog.
Thanks, Chris. I'll go there next.
Here is the specific article I think he is referring to. http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/[/url]
Thanks, Sean.
October 14, 2016 at 6:45 am
Lynn Pettis (10/13/2016)
Sean Lange (10/13/2016)
Lynn Pettis (10/13/2016)
I am really getting tired of Mr. Celko. And obviously he is losing it as he can't seem to type English sentences without stammering.No kidding. I get the gist of his post but the actual words written are rubbish. They sentences are so completely mangled as to make his whole post uesless.
I love my career, I love the company where I work, but between Mr. Celko and the new breed of entitled worker I am starting to think about retirement. Granted I have about ten years or so before full retirement age, but not sure I will make it and still be at least some what sane.
I have started looking at ex-pat retirement looking at places like Costa Rica, Ecuador, Thailand, Ireland. So far those places look like affordable locations should Social Security still be around.
I'd suggest that you rule Ireland out of that list. It's not particularly affordable and the weather is, let's be generous, average. Ecuador, however, looks rather good. Retirement sounds good to me too: I like my job, but I'd rather play guitar 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 14, 2016 at 7:00 am
Lynn Pettis (10/13/2016)
Wow, what an answer to a 2 year old thread. No idea where they came up with that idea.
Amazing!!! That "answer" is as vague and useless as the original question. It might be an answer but we don't have a question for the answer. :hehe:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 14, 2016 at 7:05 am
Sean Lange (10/14/2016)
Lynn Pettis (10/13/2016)
Wow, what an answer to a 2 year old thread. No idea where they came up with that idea.Amazing!!! That "answer" is as vague and useless as the original question. It might be an answer but we don't have a question for the answer. :hehe:
What do you get when you multiply six by nine?
:hehe:
October 14, 2016 at 7:15 am
jasona.work (10/14/2016)
Sean Lange (10/14/2016)
Lynn Pettis (10/13/2016)
Wow, what an answer to a 2 year old thread. No idea where they came up with that idea.Amazing!!! That "answer" is as vague and useless as the original question. It might be an answer but we don't have a question for the answer. :hehe:
What do you get when you multiply six by nine?
:hehe:
Link?
October 14, 2016 at 8:05 am
Luis Cazares (10/14/2016)
jasona.work (10/14/2016)
Sean Lange (10/14/2016)
Lynn Pettis (10/13/2016)
Wow, what an answer to a 2 year old thread. No idea where they came up with that idea.Amazing!!! That "answer" is as vague and useless as the original question. It might be an answer but we don't have a question for the answer. :hehe:
What do you get when you multiply six by nine?
:hehe:
Link?
http://www.sqlservercentral.com/Forums/Topic1621543-2799-1.aspx#bm1825847
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 14, 2016 at 1:10 pm
jasona.work (10/14/2016)
Sean Lange (10/14/2016)
Lynn Pettis (10/13/2016)
Wow, what an answer to a 2 year old thread. No idea where they came up with that idea.Amazing!!! That "answer" is as vague and useless as the original question. It might be an answer but we don't have a question for the answer. :hehe:
What do you get when you multiply six by nine?
:hehe:
42 -- and it works in base 13!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
October 17, 2016 at 6:54 am
So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?
October 17, 2016 at 7:00 am
Spammers have upped their game recently. Some are starting to mention 'SQL' or 'database' in the subject line, the ****ers. What's the latest on migration to new forum software?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 17, 2016 at 7:02 am
Brandie Tarvin (10/17/2016)
So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?
Read those when I was much younger. Which network is putting them out?
"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
October 17, 2016 at 7:05 am
Grant Fritchey (10/17/2016)
Brandie Tarvin (10/17/2016)
So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?Read those when I was much younger. Which network is putting them out?
BBC / BBC America. Here's the website link: http://www.bbcamerica.com/shows/dirk-gentlys-holistic-detective-agency
Viewing 15 posts - 56,266 through 56,280 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply