22 September 2006
22 September 2006

The Fireside Fun of Word Squares

Here is another SQL puzzle, based on an old idea. I must confess that my investigations into ‘Fireside Fun’, are motivated by an urge to explore ways of whiling away the time during boring meetings and seminars. It is, I fear, considered rude to plug in the noise-cancelling headphones, lean back in your seat with your eyes … Read more
19 September 2006
19 September 2006

The Fireside Fun of Decapitations

You will be surprised to learn that, in the nineteenth century, they got on perfectly well without television or computer games. Actually, in the evenings they were accustomed to organise all sorts of entertainments we have since forgotten about, all of which required the art of human interaction. After their evening meal in any affluent household, … Read more
17 February 2006
17 February 2006

Intelligent Database Design Using Hash Keys

Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows? Then you will notice the impact both in terms of storage requirements and search performance.… Read more
18 January 2006
18 January 2006

A case for canned SQL

Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many of the proponents of the dynamic argument are web or Access developers, or developers of some other front end. Arthur takes another look at the argument.… Read more