Here's a naming option some people are really going to hate:

Mostly use mixed case to name your tables. Examples:

. FacilityPerson

. ...

Most of these replies seem to be from people who work in companies that have people who *could* act as backup if the interest and will was there. I...

What a timely article for me. I recently found out that I might have to do some queries/reports off of another agency's Oracle database. I've only worked with...

Ravi: The problem was that I didn't have an alternative answer. All I knew was that say the third letter had to be a 'p' instead of a...

I have 3 more suggestions:

1) make it easy for everyone who participated (ie, sent in their best guess at answers) to get the official answers. If the official method...

I enjoyed doing the puzzle. I'm not a DBA per-say and so it was fun to see how many I could get on my own and how many answers...

Where do we look for those answers? When I go back to the article, all I see is the puzzle.

Thanks,

- JJ

Thanks to Mike C. for the MS Connect items. Amen!

Nice check list.

Great article. Jeff, you have a wonderful knack for explaining things. Even someone new to tally tables would be able to follow your article and absorb the idea.

Stephen: Thanks for the additional clarification. That helps.

Stephan: Thanks for the reply. If I understand you correctly, you are suggesting that I could create a delimited text file, but instead of using a comma, I...

I certainly would rather use CSV for transfering data/communicating between databases/servers any time just because it is a million times easier and faster to create, human-read, and code-read.

So, I use...

Great article. We have all heard not to use SELECT *, but this is a concrete example of why. I generally stay away from SELECT * just for...

I think this is a great article. I like that you explain the concept and then explain the pros and cons.

I understand the difference between the subject of...