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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
