Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 51,631 through 51,645 (of 66,712 total)

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

I see the spam bomb went off again today. What's with the online TV stuff. It's almost as if the reddit links are multiplying.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 2

Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎

Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.

Can Oracle have left / right INNER JOINs?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?

Not back when I used it. Maybe I just need more caffeine, but I don't see the point.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?

By definition, there can't be a left/right inner join.

My guess is that he got confused similar to some interviewees I had who said that there were 5 different kind of joins: join, inner join, outer join, left join and right join (no full nor cross).

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 5

Luis Cazares (11/30/2015)
Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?
By definition, there can't be a left/right inner join.
My guess is that he got confused similar to some interviewees I had who said that there were 5 different kind of joins: join, inner join, outer join, left join and right join (no full nor cross).

Well, he's a server guy who learns bits and pieces of programming languages as he needs them (PERL, SQL, etc.), so it's probable that he just got the terms mixed up because he only learned the one little bit of code.

He was so proud of himself for solving a problem that no one else (not even the Oracle devs) were able (or more likely willing) to solve.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 6

Brandie Tarvin (11/30/2015)
Luis Cazares (11/30/2015)
Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?
By definition, there can't be a left/right inner join.
My guess is that he got confused similar to some interviewees I had who said that there were 5 different kind of joins: join, inner join, outer join, left join and right join (no full nor cross).
Well, he's a server guy who learns bits and pieces of programming languages as he needs them (PERL, SQL, etc.), so it's probable that he just got the terms mixed up because he only learned the one little bit of code.
He was so proud of himself for solving a problem that no one else (not even the Oracle devs) were able (or more likely willing) to solve.

It would be interesting to see a venn diagram that shows how a LEFT INNER JOIN works.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 7

So, it would simultaneously return only matching rows from both inputs, and yet all rows from the left input. Maybe a .gif with the intersection shaded, and the non-intersecting portion of the left circle oscillating between shaded and not?

:hehe:

Robert Sterbal SSChampion Points: 11050 More actions · Answer 8

Images:

https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746

Search:

https://www.google.com/search?q=venn+diagram+left+outer+join

412-977-3526 call/text

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 9

robert.sterbal 56890 (11/30/2015)
Images:
https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746
Search:
https://www.google.com/search?q=venn+diagram+left+outer+join

Nice references for a real join type; the actual topic of conversation, the mythical LEFT INNER JOIN, will prove more elusive. 🙂

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 10

Alan.B (11/30/2015)
Brandie Tarvin (11/30/2015)
Luis Cazares (11/30/2015)
Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?
By definition, there can't be a left/right inner join.
My guess is that he got confused similar to some interviewees I had who said that there were 5 different kind of joins: join, inner join, outer join, left join and right join (no full nor cross).
Well, he's a server guy who learns bits and pieces of programming languages as he needs them (PERL, SQL, etc.), so it's probable that he just got the terms mixed up because he only learned the one little bit of code.
He was so proud of himself for solving a problem that no one else (not even the Oracle devs) were able (or more likely willing) to solve.
It would be interesting to see a venn diagram that shows how a LEFT INNER JOIN works.

Possibly someone missed the OUT keyword, should have been LEFT OUT INNER JOIN, the Venn diagram looks exactly like a view of a black hole beyond the event horizon, if you've seen it it's too late:-P

😎

Robert Sterbal SSChampion Points: 11050 More actions · Answer 11

robert.sterbal 56890 (11/30/2015)
Images:
https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746
Search:
https://www.google.com/search?q=venn+diagram+left+outer+join

It is redundant, but is used quite frequently:

http://stackoverflow.com/questions/2389204/left-inner-join-vs-left-outer-join-why-does-the-outer-take-longer

412-977-3526 call/text

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 12

Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.
And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?

The most rational explanation would be a left outer join turned inner by a subsequent conditionals, i.e. a where clause, normally if one tries to filter on a left table column the optimizer translates/forms the query as to an inner join as it translates to the same. You might want to point out that any directive such as LEFT, CROSS, RIGHT and FULL before INNER are syntax errors.

😎

Sean Lange SSC Guru Points: 286590 More actions · Answer 13

robert.sterbal 56890 (11/30/2015)
robert.sterbal 56890 (11/30/2015)
Images:
https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746
Search:
https://www.google.com/search?q=venn+diagram+left+outer+join
It is redundant, but is used quite frequently:
http://stackoverflow.com/questions/2389204/left-inner-join-vs-left-outer-join-why-does-the-outer-take-longer

Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is about somebody discussing LEFT INNER join which is almost as elusive as a gold pot carrying leprechaun or a flying unicorn. 😀

_______________________________________________________________

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/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

Sean Lange (11/30/2015)
robert.sterbal 56890 (11/30/2015)
robert.sterbal 56890 (11/30/2015)
Images:
https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746
Search:
https://www.google.com/search?q=venn+diagram+left+outer+join
It is redundant, but is used quite frequently:
http://stackoverflow.com/questions/2389204/left-inner-join-vs-left-outer-join-why-does-the-outer-take-longer
Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is about somebody discussing LEFT INNER join which is almost as elusive as a gold pot carrying leprechaun or a flying unicorn. 😀

I am reminded of Jeff Dunham and Peanut.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 15

Lynn Pettis (11/30/2015)
Sean Lange (11/30/2015)
robert.sterbal 56890 (11/30/2015)
robert.sterbal 56890 (11/30/2015)
Images:
https://www.google.com/search?q=venn+diagram+left+outer+join&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwih1NmZgrnJAhULFj4KHV4hCuAQsAQIJA&biw=1409&bih=746
Search:
https://www.google.com/search?q=venn+diagram+left+outer+join
It is redundant, but is used quite frequently:
http://stackoverflow.com/questions/2389204/left-inner-join-vs-left-outer-join-why-does-the-outer-take-longer
Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is about somebody discussing LEFT INNER join which is almost as elusive as a gold pot carrying leprechaun or a flying unicorn. 😀
I am reminded of Jeff Dunham and Peanut.

Anyone know if a RIGHT INNER JOIN performs better than a LEFT INNER JOIN?

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]