I think those goes even further back to whether or not use hungarian notation. Its preference until you consider the statement "

11:31 what happens when I create a data warehouse with a bunch of "name" fields"

Now you have to take your data model and implement something else based on it so your naming conventions turn in to a portability and maintainability issue.

Granted that Jon's follow-on has merit as well but how much of your initial design thought was about building a data warehouse. If you say you did think about it and that your database is normalized then you ignored what you thought about.

All I am saying is that you should think about the whole solution and how you can make it easier to maintain and such. The table should describe the context of the data it contains.

Naming conventions are only preference if the code/model won't be used by somebody else in some other way.

John Lamb
Sr Principal Software Engineer
L-3 Communications

PS-If everybody is concerned about data warehousing then why can I only get a six month history from my Bank of America account?