The VALUES clause or building tables out of nothing

The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.

Combinations, permutations, and derangements

Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.

The problem with averages

Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.

Much Ado about nothing: missing data

Joe Celko explains how missing data is handled from the printing press to databases.

Constraints and declarative referential integrity

Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.

Halloween Protection

Intersection

Halloween Protection

ACID Properties

NUMA