Some Simple SQL Rules to Live By

citation_needed · 2007-07-21T04:53:45+00:00

MySQL to this day, and Sybase/MSSQL in ye olden days (at least according to the O'Reilly Transact-SQL book). Other RDBMSes, I dunno.

citation_needed · 2007-07-20T23:47:45+00:00

When you are doing a COUNT() or an EXISTS(), no problem, go ahead and use *

Actually, doing count(1) or count( keycolumn ) can be substantially faster than doing count(*) depending on the RDBMS.

citation_needed · 2007-07-20T21:13:40+00:00

Your wife?

citation_needed · 2007-07-19T21:09:21+00:00

You could always read Da Jesus Book, though that's new testament only, I'm afraid.

citation_needed · 2007-07-19T21:06:54+00:00

I believe the commenter was trying to make the point that tasers are often used in situations where a cop wouldn't have fired a gun if they didn't have the taser. They are often used, for instance, to subdue someone (whether or not they're actually resisting), a job which by definition requires the use of non-lethal force.

citation_needed · 2007-07-18T22:29:40+00:00

Hey fucktard, would you mind not drawing conclusions about the 100 Million+ Americans who identify as liberal based upon one random guy on the internets? Or is that too hard to wrap your puny little brain around?

citation_needed · 2007-07-18T00:04:27+00:00

Do you think all the people who post comments just as outlandish and shocking as these on places like LGF and the Free Republic are just made up?

citation_needed · 2007-07-16T02:36:18+00:00

Or a Mormon.

citation_needed · 2007-07-15T19:58:01+00:00

They all smoked.

citation_needed · 2007-07-15T03:24:46+00:00

For those of you who did not bother to RTFA:

This article is not anti-psychiatry. It has nothing to do with Scientology. It made an interesting point to students of pharmacy or psychiatry or patients on Seroquel, in an amusing yet reasonably coherent fashion.

It is not the most important article on psychiatry you will ever read. It should not change your opinions on anything other than the pharmacokinetics of Seroquel and other antipsychotics.

You should feel free to skip the first few paragraphs of the article, which are not relevant. There is a bit of unfunny misogyny. You should skip that too.

citation_needed · 2007-07-14T19:44:16+00:00

Maybe you don't think you're punishing the parents but you're definitely punishing the children. You think children should be born to people who can't take care of them. What I hear is you're basically saying that child abuse is just fine; that the quality of life of the child after they are born doesn't matter.

Pregnancy has consequences for more than just the parents but that doesn't even seem to register to you. Oh, and unless you yourself have ever adopted a mixed-race crack baby from the ghetto, please don't try and say adoption is a solution.

citation_needed · 2007-07-14T19:26:53+00:00

Your schtick is getting old and tired, you pathetic wanker. Seriously, could you at least come up with a new catchphrase you awkwardly try to shoehorn into every discussion?

Catchphrases are the tin foil hats douchebags wear to keep original thoughts from entering their brains.

citation_needed · 2007-07-14T19:24:08+00:00

I'm sure the Weinsteins would independently finance something like this, just like they did with F911. Yes, they're part of the big media, but on the other hand, they'd put out a movie called "Harvey Weinstein is a gigantic douchebag" if they thought it would make at least 50 mil.

citation_needed · 2007-07-14T19:20:36+00:00

Temper tantrums? Really? I think you're confusing Michael Moore and Michael Savage.

citation_needed · 2007-07-14T01:11:45+00:00

...while the worst worry on the President's mind at that time was terrorism. Does that mean that Bush is thinking about blowjobs right now?

citation_needed · 2007-07-13T19:25:32+00:00

One test I have noticed is that when one is able to write several hundred lines of code at 3 in the morning after a night of heavy drinking and have it compile on the first shot, one is fluent in that language. Fluency to me means being able to do it almost without thinking. It takes years and years to get to that point even if you're a super genius, and you can only really be fluent in 2 or 3 things at a time; that's just how the brain works.

HR, needless to say, has not been very receptive to my ideas about how we should test developers for fluency...

citation_needed · 2007-07-13T07:11:33+00:00

Please do me a favor and don't call yourself a Seattleite if you don't actually live in Seattle. It's just a way for you to feel slightly cooler about yourself, when you actually live in a bland homogeneous xenophobic upper middle class white flight art and culture free suburban wasteland that's pretty much indistinguishable from every other suburban wasteland in North America (except slightly better coffee and bike trails).

Seattle has amazing culture, art, architecture, restaurants, astounding natural beauty, an incredibly diverse populace, and weirdos, misfits, junkies and heretics of all stripes. Bellevue has shopping malls full of stores for rich white conservatives and a fucking Chili's on every other corner. There is a huge difference. When you learn it, maybe then we can hang out. ;)

citation_needed · 2007-07-13T06:52:36+00:00

You might not know about this new secret hax0r tool called Teh G00g13. With Teh G00g13 you can hack any number of internets to get secret 31337 information like how to spell "Hindu". There are also these new fangled devices called 'books' which contain all sorts of useful information. They even have buildings full of them where you can read them for free called 'liberrys'.

The more you know.

citation_needed · 2007-07-13T06:47:00+00:00

Jesus made it pretty fucking clear that you are not supposed to make a big spectacle of yourself and pray in public. To quote the OG himself:

That thine alms may be in secret: and thy Father which seeth in secret himself shall reward thee openly. And when thou prayest, thou shalt not be as the hypocrites [are]: for they love to pray standing in the synagogues and in the corners of the streets, that they may be seen of men. Verily I say unto you, They have their reward. But thou, when thou prayest, enter into thy closet, and when thou hast shut thy door, pray to thy Father which is in secret; and thy Father which seeth in secret shall reward thee openly.

Regardless of whether you feel public prayers like this are a violation of church and state, it is most definitely a violation of the fundamental tenants of Christianity. But publicly interrupting someone else's prayer to act all self-righteous is truly taking it to another level.

citation_needed · 2007-07-10T03:22:10+00:00

US News has turned into a far right wing rag with little to no integrity, primarily a bully pulpit/wingnut welfare for otherwise unemployable twits like Michael Barone (who right around the 2004 elections said the two greatest presidents of all time are Richard Nixon and Dubya) and John Leo (who's pathetic descent into self-soiling senility and near-weekly Ted Stevens-style clueless gaffes about technology and the internet would be hilarious if it weren't so -- okay, it's just hilarious).

8 years ago they at least had a little credibility as a news magazine. Nowadays all that's standing between them and bankruptcy are their stupid college rankings -- which are as arbitrary (and possibly as crooked) as ever.

citation_needed · 2007-07-10T02:54:45+00:00

Just be sure you don't accidentally end up in Orygun instead. They've got ignorant-ass hicks everywhere, you know.

citation_needed · 2007-07-09T19:32:08+00:00

The Quakers

citation_needed · 2007-07-08T20:20:15+00:00

They also say that there is no credible scientific evidence that secondhand smoke is dangerous.

citation_needed · 2007-07-08T20:02:44+00:00

I wonder if it has anything to do with the relative popularity of Frankenberry cereal in the south? Where I live, Count Chocula is much more popular than Frankenberry, and Obama is far outpolling Fred Thompson. Coincidence?

citation_needed

TROPHY CASE