Re: Parts explosion with repeated subtrees

> Actually, I was thinking about doing book six on either data quality
> or on how to write bad SQL. We have poor data quality in database, so
> this is a good topic. We also have new SQL programers who are
> determined to write bad code, so perhaps a book that shows them the
> common errors would help.

Damn, that's a good topic!

When I think of the number of bad databases I've seen, and the number of bad queries I've seen against pretty good databases, I think there's a gold mine there. And the thing is, the same errors seem to keep on cropping up. People have these fixed ideas about how they can improve on the relational model, and reduce the number of joins, without ever really getting a clear idea of how the engine really works. And they don't know how to map reality into relations!

I suppose, if you called it something like "SQL from Dummies", you'd get sued. Good luck, Joe!

--
Regards,
    David Cressey
    www.dcressey.com