Every Bucket Deserves a Descriptive Name
July 28, 2010 Hey, Guru
One of the fun things about editing this newsletter is reading the interesting ideas I get from you, the readers. One reader in particular, one of the several David’s from whom I hear, comes up with interesting questions, comments and ideas. Here’s an SQL tip he came up with. I thought I’d share it with you. Many of us use files with “buckets” (a list of repeating fields), in order to easily present data to users in an intuitive format. A file with repeating fields violates First Normal Form (1NF), and can cause grief when the number of buckets must |