Tip Bank

Question: Someone told me I have to specify a MIME encoding somewhere on my server. Would you be kind enough to tell me where on a Windows NT server Internet

Question: [Joe Celko’s One In Ten Puzzle]Alan Flancman ran into a problem with some legacy system data that had been moved over to a SQL database. The table looked like

Question: [Joe Celko’s Milestones Puzzle]This puzzle, in a little different form, came from Brian Young. His system tracks a series of dates (milestones) for each particular type of service (tos)

Question: We have several heavily-used tables with lots of columns (average around 30 columns), and the users are getting locked out frequently. We’ve thought about splitting the tables, but didn’t

Question: Data field objects in OPO can accept any amount of data, but if I send too many characters to the server, I get an error “flushing the row to

Question: [Joe Celko’s Budget Versus Actual Puzzle]C. Conrad Cady posted a simple SQL problem on the CompuServe Gupta Forum. He has two tables, Budgeted and Actual, which describe how a

Question: [Joe Celko’s Dataflow Diagrams Puzzle]Tom Bragg posted a version of this problem on the CASE Forum on CompuServe. You have a table of dataflow diagrams (DFDs), which has the

Question: How are transactions handled in OPO? Answer: Transactions are the core of multi-user data processing integrity. A transaction defines an all-or-none unit of work. The classic example of a

Question: When I open a session to an Oracle database, I can’t see any tables other than those owned by my user name. How can I get access to tables