Tip Bank

Question: [Joe Celko’s Pension Plan Puzzle]Luke Tymowski, a Canadian programmer, posted an interesting problem on the MSAccess forum on CompuServe in 1994 November. He was working on a pension fund

Question: [Joe Celko’s Phone Book Puzzle]You are trying to set up an office telephone directory and have the following tables: CREATE TABLE Employees (empid INTEGER PRIMARY KEY, firstname CHAR(20) NOT

Question: I see the term “AFX” everywhere in the MFC source code.For example, “AFX_MSG_MAP”. What does it mean? Answer: I once asked this of Jeff Harbers, one of the original

Question: (Joe Celko’s Least Little Thing Puzzle)Gregg Reno asked for an answer to a “Simple SQL puzzle” on the SQL Roundtable section of the DBMS CompuServe forum in March.He wanted

Question: Joe Celko’s Store Survey Puzzle]You are collecting statistical information stored by the quarter hour. What your customer wants is to get information by hour ? not on the hour.

Question: Please explain Dynamic Worlds. Answer: “The Power of Dynamic Worlds” proposal from the German National Research Center (GMD) is based on an interaction model developed for collaborative distributed virtual

Question: [Joe Celko’s Outer (JOIN) Limits Puzzle]Gerard Manko at ARI had a problem in 1994 April. They had just switched over from Paradox to Watcom SQL. The conversion of the

Question: [Joe Celko’s Promo Puzzle]Let’s assume that you have just gotten a job as the sales manager for a department store. Your database has the following two tables. One is

Question: [Joe Celko’s Production Report Puzzle]We get a production report from work centers which has a date, center code and how many widgets were produced from each batch of raw