Re: Stupid Database Tricks

This thread is funny in a sad way:)

1. Never use a VIEW; load the data into temp tables on the fly with updates and inserts. But then forget that the base tables that built that data have changed since the last time you looked at the temp tables.
2. Find a problem (extra blanks in text, out of range numbers, whatever)during a regular program execution. Fix it in the front end code and don't tell the DBA so he could add a CHECK() constraint or something that would help everyone.
3. Do not put comments in SQL.