KoldCoffee (5/21/2013)
Careful thought before I ask the following:Would it be ok with you not to post to my topics for about 6 months? There are so many people on the forums to help and I am not posting every day or every week, but every time I do you are on there! Even Celko does not get on me every single time about my DDL not being fully normalized and datatypes correctly defined. You know, DDL is often created to be adequate for illustrating the problem...etc. and Celko, while he *has a point* is heavy handed with it at time where it is clear the person posting is not addressing normalization.
I have never gone off on anyone for posting table definitions that were not normalized or did not have PK defined, or weren't using proper data types in the manner of Mr. Celko. I may mention that dates should not be stored as integer or character values, but I also realize that you sometimes are stuck with the decisions of others. I do recommend trying to change those but again realize that may not be possible.
Depending on the problem, we may suggestion that data may need to be normalized as well, but we try to work with what is provided because that is what you have to work with.
As for not answering any of your posts for 6 months, you will probably get that wish not because I pay attention to who is posting (as I told you in a PM, I rarely look at the who when responding) but because I may simply not be able to answer as many questions as my internet connections may not be a fast and/or reliable while I am in Afghanistan. Until I leave, however, if I answer your question(s) I answer your question(s).