They also serve as a great list of 'bad coding practice' i.e things NOT to do in the first place. If you are learning SQL or revising / updating your knowledge they also make great reading.
In short, 'Learn from the mistakes of others '...
Further Reading -
- Bad habits to kick : inconsistent naming conventions
- Bad habits to kick : using SELECT or RETURN instead of OUTPUT
- Bad habits to kick : using dashes and spaces in entity names
- Bad habits to kick : declaring VARCHAR without (length)
- Bad habits to kick : using table aliases like (a, b, c) or (t1, t2, t3)
- Bad habits to kick : using old-style JOINs
- Bad habits to kick : using loops to populate large tables
- Bad habits to kick : ORDER BY ordinal
- Bad habits to kick : abusing triggers
- Bad habits to kick : choosing the wrong data type
- Bad habits to kick : making assumptions about IDENTITY
- Ladies and gentlemen, start your semi-colons!
No comments:
Post a Comment