Phil Factor's Phrenetic Phoughts

Simple-Talk columnist
The wilder shores of Transact SQL    Phil on Twitter   Phil on SQL Server Central"

The Pub Lunch and Programming.

Published Thursday, May 04, 2006 2:36 PM

"Werry good poer o' suction, Sammy," said Mr Weller the elder, looking into the pot, when his first-born had set it down half empty. "You'd ha' made an uncommon fine oyster, Sammy, if you'd been born in that station o' life,"
Charles Dickens, The Pickwick Papers

One of the great pleasures of programming in a team is the pub lunch. It is something I always relish, particularly on a Friday, for the refreshments, the gossip and the companionship. I thought that this ancient ritual was an international one until I worked for a while in Japan, and discovered to my horror that it was soft drinks only until the sun went down. At first I thought this was due to their abstemiousness until I saw the propensity of the Japanese engineer or programmer for consuming the stuff once the sun had dropped.

Nevertheless I always wondered whether there was a moral dimension to celebrating the end of the working week with a couple of pints of best Bitter. Is it true that one's capacity for work drops after the Amber Nectar has hit the bloodstream? I have always doubted it. Do careless errors slip into ones' code after the beverage hits the bladder? My own experience tells me not. Once the warm glow of the hops descends on my soul, I feel calmer, and more confident. and less distractible. My best ever code has, I have always considered, been written with a jar of Stout in one hand and a cigar in the other.

There will be some, particularly those with the cold grey ice of Puritanism in their souls, who will click through their teeth and protest that I would be better off drinking water and breathing in fresh invigorating air.

This should be put to the scientific test. I have of course done the best I can but my results are merely indicative. I have conscientiously plotted the average number of times I have hit the compile button before a stored procedure has compiled without errors, against the number of half-pints of Beer I have consumed. The data was collected over a period of a month. The results, for what they are worth are:

Consumption Errors per Stored Procedure
Sober: 4
Half a pint 3.2
One pint 2.87
One and a half pints 3.2
Two pints 4.8

The problem with these results is that they take no account of the 'Placebo Effect'. My error-rate may be more closely related to my subconscious will to come up with the result I want. For a controlled experiment, a whole range of programmers, selected by random numbers and balanced so as to represent a true sample of the population of programmers, should be given both real beer and an alcohol-free 'Placebo' beverage that is indistinguishable from it. It should be done at various times of day with a full range of database tasks. It is an indictment of the poor state of academic psychology that such a task has not yet been undertaken. Of course, for all I know, a PHd thesis may already lie neglected in some university library with the truth already firmly established

Should the community of database developers and DBAs unite to determine this issue once and for all? If it can be proved beyond all doubt that a good beer actually improves ones programming skills then maybe one can claim the cost of purchase against tax?

Your views and comments would be most welcome.

If it be true that I do think
There are five reasons we should drink;
Good wine, a friend, or being dry,
or lest we should be by-and-by
or any other reason why
Henry Aldrich, Dean of Christ Church Oxford

Comments

 

Flibble said:

I'd say that many of my most enlightened ideas have occurred after the benefit of the odd beverage or two. My brain drops out of its comfort stirrups and slowly descends into the melting pot of alcohol flavoured idea juice.

It was during one of those moments that I hit upon the idea of a Sandwich-o-matic re-baconizer. Fairly self explanatory in name, but cunningly differentiated from imitators by the use of self propagating bacon. By simply filling your sandwich with pig feed pellets and positioning it behind an abattoir and barbeque (both positioned on a steep incline) - the bacon comes to you.

I must try this Friday lunchtime pub lunch thing you speak of...
May 4, 2006 5:19 PM
 

Arthur M. said:

It is strange that the most successful IT industries are in parts of the world with the highest consumption of Beer. Purely on those parameters, wine is not so good as beer, so it is possible that the Hop has a secret ingredient that promotes the art of Programming.

Notice also that the IT industry is floundering in strict Muslim countries where alchoholic drinks are banned, whereas I know of several highly gifted Muslim programmers. As soon as they get their chins into a beergless their productivity soars.
May 5, 2006 11:13 AM
 

Phil Factor said:

Actually, Flibble, the Pub Lunch with which you are unfamiliar can be enjoyed on other days of the week, but the advantage of Friday Pub Lunch is that it is guilt-free, and less hurried. Or so I am told.....
May 5, 2006 11:26 AM
 

Rodney said:

With all things good, as beer and spirits, knowing the defining line between ultimate productivity and being sad dolt who is blubbering away to old Hank Williams songs while "hails of derisive laughter, Bruce" play through your mind....wait. That was last weekend. And I proudly state, I write this now on Cinco de Mayo and after 4 Margaritta's and 2 Tecate's. Fortnately, it is not code I am writing. I will try a poem later in my blog.
There once was a man from a bucket
whose home was nowhere near Nantucket.....
May 5, 2006 7:48 PM
 

Phil Factor said:

There once was a man from a bucket,
who lived far away from Nantucket
he would casually say 'O
on Cinco De Mayo..'
whilst living near Bexleyheath, Fu**it!

(One pint of Nethergate Umbel Ale)
May 6, 2006 1:50 PM
 

J Walker said:

The Blog Entries done by Rod Landrum
are tending to pose a conandrum.
Is all his work done
on the beach in the sun
or is he a bogus Panjandrum?

(One cigar and a bottle of Sauvignon)
May 6, 2006 2:15 PM
 

Organthruster said:

A large Santa Damiana curling smoke over one hand and a glass of Bombay Sapphire in the other might break God's warranty - not to mention Allah's rules - but they do have the effect of magnifying your noodle's power. How, I don't know. But you only have to read a page of Douglas Adams to see what a pint of beer and a smoke can do for creative thinking. Though you have to be careful. I've recently tipped a full glass into my keyboard while reaching for the cigar, and with all that sugar sloshing about the keys soon had the feel of AM/FM radio presets on a 1985 Austin Montego. If the issue is to be determined properly and scientifically, we need to factor in stoppages for such things: presented with about eleven hundred keyboards at online retailers, it took me an hour to decide upon the replacement. My only advice is to choose diet tonic.
May 6, 2006 2:39 PM
 

Adam Machanic said:

I would love to assist you with the scientific study, but we first need to identify a N/A beer that tastes even remotely like the real thing. I believe that will be the most difficult part of the study.

By the way, I've long held that I do my best work after two or three beers. One is not enough (just makes me a bit tired), and four is too many (makes me a bit tired). It's all about achieving that 2-3 beer lucidity.
May 8, 2006 5:33 AM
 

Jamie said:

2-3 pints of beer can certainly make testing more interesting.
May 8, 2006 3:34 PM
 

Adam Machanic said:

Testing?!? Pfft! After 2-3 pints, my code needs ABSOLUTELY no testing! Just go ahead and production it right to ship! ... And then get me another pint! :-)
May 8, 2006 8:04 PM
 

Rudy said:

It appears as though the ever present 'bell shaped' curve is upon us again. Now if only societal mores would cooperate ...
May 8, 2006 11:11 PM
 

Phil Factor said:

The art of testing is so entirely different from the art of developing that it comes with its own rules. I suspect that testers do best to stay entirely sober during work hours, and we, in turn, should not gloat over the splendour of our liquid lunches as a mark of respect.
I'm not entirely sure whether sobriety in managers is a good idea or not. I'm not sure if it has been tried.
May 9, 2006 9:36 AM
 

Flibble said:

May 12, 2006 12:11 PM
 

Phil Factor said:

A terrifying change has come over our society, as this quote from the article Flibble spooted says:
"Now it's more likely to be a round of fizzy water and fruit juice," says Mr Jones.

My favourite pub, once full of alchohol fumes, tobacco smoke and the smell of sweat, with sawdust on the floor and gnarled old bors in cloth caps, is now a 'nouvelle-cuisine' namby-pamby restaurant full of retired bank-managers and piped 'calming-music'. Damn the new puritanism!
May 12, 2006 4:59 PM
 

Rob W said:

Tequila? Bourbon? Vodka? Phil, you should look at expanding the research to include a variety of drinks. I'm of the belief that, whilst beer is a good base line for the test, we should be looking at Jose Cuervo for productivity improvements.
May 18, 2006 3:52 AM
 

Phil Factor said:

I have, of course, been experimenting with a variety of alchoholic drinks. I find that the 'purer' alchoholic drinks such as Rum, vodka and Whiskey are hopeless for enhancing the programmers productivity. It would be fascinating to get the view of others on this point. At the moment, I rate a good 'Hoppy' Draught beer as ideal, but a number of liqueurs such as Benedictine are excellent. Ideally, we need to extend this research into a global project to find the ideal tipple for the working programmer. What is the view of programmers in Russia or the far east?

I must, of course, cast a note of caution about the over-use of coffee and caffeine drinks. The error rate increases along with the manic delusion that one is doing something wonderful and ground-breaking. As the caffeine kicks in, the idea of defensive programming, and testing get lost in the general frantic activity.

Give me, at any rate, the tranquility, the sober realism and spiritual quietude of a good dose of hops, and let the new puritains sip their wretched bottled water.
May 18, 2006 8:21 AM
 

Mike said:

Bill Wilson also believed in this correlation: "We had long talks when I would still her forebodings by telling her that men of genius conceived their best projects when drunk; that the most majestic constructions of philosophic thought were so derived."

from end of paragraph 1 on page 2 in the following pdf: http://www.aa.org/bigbookonline/en_BigBook_chapt1.pdf

Bill Wilson is listed in Time's as one of the 100 omst important individuals in the 20th century. http://www.time.com/time/time100/heroes/profile/wilson01.html

Bill Wilson later founded Alcoholics Anonymous.
May 23, 2006 1:52 PM
 

Phil Factor said:

I think we should all raise our glasses to the memory of this great man.
June 12, 2006 9:19 AM
You need to sign in to comment on this blog

















<May 2006>
SuMoTuWeThFrSa
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
Virtual Exchange Servers
 Microsoft now supports running Exchange Server 2007 in server virtualization environments, not just on... Read more...

Virtualizing Exchange: points for discussion
 With the increasing acceptance of the use of Virtualization as a means of providing server... Read more...

Encouraging .NET Reflector Add-ins
 Jason Haley is well-known for the resources he's provided to developers who wish to extend Reflector's... Read more...

Using .NET Reflector Add-ins
 .NET Reflector by itself is great, but it really comes into its own with the help of some add-ins. Here... Read more...

Unique Experiences!
 You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause a lot... Read more...