I am curious how religiously people stay true to using data types for MS SQL Server. I know some of these stretch to other RDBMS's, however, I would like to know what people in industry think. What type of general rules of thumb do people follow when planning data types for a data store? For instance Money, Numeric, varchar, int, bigint ... I think you get the point.
I am looking for response such as; never use that type, it won't convert to Oracle. Never use that type, the space you save is not worth it, etc.... If this needs more elaboration, please let me know Mike. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
