thinking clearly

mwf's picture

Predicate relations or join on clause

Some of my friends vehemently prefer the SQL-89 predicate relations definition of joins.

Some of my friend vehemently perfer the SQL-92 “join on” clause, aka ANSI joins (which always puzzles me since I think both are defined in ANSI standards.)

 

Some folks (and this probably doesn’t include my friends) have called the Oracle join specification (+) “an abomination.”

I think each has strong points and drawbacks. In Oracle both are still legal.

In which syntax is it quicker to discover all the tables involved in a particular query? (hint: the one where you list all the tables immediately after the from clause.) Of course inline views and “with” common table expressions have diluted that old advantage of ’89.

mwf's picture

Short and sweet: What do you think of when you hear “Republicans?”

Oddly this was a discussion topic on Amazon. Most of it was vitriol from folks who have been schooled to hate Republicans. As a Republican, I know we get a bad rap and often our predominant touted feature is a confusion that we are against stated goals rather than being against the stated means of attempting to achieve those goals.

So here is my answer: What do you think of when you hear “Republicans?”

Folks who want to efficiently create a safe and prosperous society who end up spending all their time trying to stop the Democrats from pursuing stupid, hateful, and wasteful policies that would never work to achieve the laudable goals they claim the policies pursue. Unfortunately the Republicans are then cast as being against those goals, most of which they also support.

mwf's picture

What’s more sexist: Time’s question or Sandberg’s response?

So I was reading Time’s September 22, 2014 edition and came across 10 questions for Facebook COO Sheryl Sandberg when I reached this absolute gem:

Why do you think women are so afraid of making mistakes?

WOW. So in the question women are defined as being afraid of making mistakes. Now I don’t know whether this comes from Charlotte Alter (the by line for the 10 questions) out of whole cloth or whether it was inspired by something Sheryl Sandberg wrote or said previously of which I’m not aware.

In my book attributing qualitative faults (like fearing making a mistake) to one sex as opposed to another is pretty much the definition of sexism. I’m not saying the sexes cannot be compared. On average men are taller than women. More women have wombs than men. Calling out objective differences of fact is not sexist in and of itself.

mwf's picture

Back to technology: Is it effective to place Oracle REDO on SSD?

Ever since I was asked to improve the throughput of an actual general ledger posting job involving Oracle in December 1993 on some hardware where solid state disk (SSD) was available (at high cost relative to “spinning rust” or hard disk drives [HDD]), I have been trying to explain the overall advantage of placing different types of the different Oracle storage selectively on SSD.

When FLASH SSD arrived on the scene, studies quickly arose that writing to FLASH SSD is often not as fast as writing to disk drives dedicated to receiving those writes.

Today I’ll try to explain why I don’t care.

While there was some advantage to writing to SSD in my tests (which were to RAM based SSD on a VAX), the write speed to online REDO was not a significant part of the advantage of placing online REDO on SSD.

mwf's picture

The primary election is over. Sadly, I did not win.

Either the power of social networking is not yet up to the task of overcoming television ads and the visual and other pollution of yard signs EVERYWHERE, or New Hampshire is not ready for the #SAFE_DEAL and to #IMPOVERISH_DRUG_LORDS. (Or, I suppose, they just didn’t like me. Quickly figuring my likely exposure, though, I believe a large percentage of folks who heard my message actually voted for me. So maybe I just need to get better and spreading the word at low cost. I do find it ironic that MAYDAY pac endorsed a candidate who did spend money on the grounds he pledged to fight against large campaign media budgets in the future, while I operated on a minimal media budget. Notice that is not a criticism of the candidate they did endorse.)

Anyway, completely cribbed from WMUR-TV’s site, here are the apparent 99% returns:

Brown, Scott 58,635    50%  Rubens, Jim   27,048 23%  Smith, Bob     26,483 23%

mwf's picture

Dear “Pro-life”: I am against abortion. But I am not against choice

If you run for office, you’ll get loaded questionnaires that essentially insist you sign up to overturn Roe v Wade. (And from the other side that you’ll sign up against things like the Hobby Lobby ruling, when the real issue is that individuals or families, not corporations, should control their own health care insurance choices.)

And let’s decode a little bit, since even the names of the movements are a lie: “Pro-life” means “I want to make abortion illegal.”

“Pro-choice” means I want the government to routinely fund abortion and make it a popular choice. I’m aligned with clinics that provide abortions and we tout the advantages to your life style of not having a child to raise or going through the inconvenience of carrying a child to term to be adopted.

mwf's picture

The #SAFE_DEAL: On the road to Equal Taxation with a baseline of the poverty level

Twenty-two years ago, when I previously ran for US Senate and began writing about reviving the idea of full support of persons legally in the country to the poverty level, we were in much better overall financial shape. An actual maximum tax would have been possible with some budget discipline. Eventually and philosophically, I think that is still the goal. If everyone made enough money to pay an equal share of the country’s budget and still be above the poverty level, that is what we should do. The philosophy is clear: One Person, One Vote; One Person, One Tax.

mwf's picture

FARNHAM for US Senate Campaign 4 Hashtags, 3 Key concepts

One of my friends noticed that I am trying to push forward campaign finance reform by trying to win without a TV media budget, and he asked what was my hash tag. DOH! I should have created hash tags long ago. Okay, there is still time to go viral. I’ve registered four hash tag definitions with hashtag.org, and I’ll explain them here, first with just the snapshot definitions I could get to stick without the site complaining : Stop! You’re posting too fast and then with the full story as individual blog posts. Hang in there. This is important.

Oh, and my top priority is establishing the #SAFE_DEAL.

#SAFE_DEAL

A system where the government makes sure all persons legally resident start with a base minimum income of at least the poverty level and get to retain at least 65 cents on each dollar they earn. See rsiz.wordpress.com for the details.

#WRONG_GAP and #CORRECT_GAP

mwf's picture

Why we should eliminate corporate INCOME taxes.

Another message from “Farnham for US Senate”

Lately, there has been a lot of news about “corporate inversion.” Essentially a large US based corporation essentially buys a foreign company based in a country with lower corporate income tax rates, but designates that the acquisition is now actually the top of the corporate structure. With this stroke of paperwork (producing nothing), the net income after taxes is improved for the stockholders. Aside from the public relations (which might be costly, especially in consumer products), this is what management should do: Maximize the returns to stockholders.

This is just a new wrinkle in the idiocy and waste that is taxing corporations on income.

mwf's picture

Some folks are STILL trying to justify violence on religious grounds. Very sad.

Christ was very clear “Love your neighbor and your enemy as yourself.” You can SAY you’re Christian and do hateful things all the time, and none of us is perfect (Methodists like to say we’re trying to keep on a walk toward perfection, knowing that is not a walk we will complete), but you really are not a Christian if you are preaching hatred of … any … one … most especially and saying this hatred comes with God’s approval. Sigh. Oh – and the bit about which prophesy is being fulfilled and when – don’t bother. He’s coming back like a thief in the night and no one will know the day or time of His Coming until it happens. Anyone who thinks they can decode specifics out of Revelations is just wrong, from Christ’s own mouth. As for extracting literal rules out of the old testament, that would be a neat trick if anyone could do it figuring translations, symbols, arcana of math and all that, but the new covenant tempered all those things with the rule of Love anyway.

To prevent automated spam submissions leave this field empty.
Syndicate content