O'Reilly logo

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13.1. Signs of Bad SQL

The phrase “original sin” always seemed to be an oxymoron; originality is an attribute that is usually missing when people—and programmers—sin. Programmers tend to make the same kinds of errors in their designs and their code over and over. They confuse RDBMS with the file systems and 3GL- or OO-oriented programming environments they first learned. The same thing happens with a spoken natural language—you first use your old grammar and syntax rules with the new words. Eventually, you use the new grammar and syntax rules with the new words.

Here are a few diagnostics you can apply simply by looking at the code. These are not in-depth analyses, but immediately visible symptoms of deeper problems. This is like a doctor who ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required