Kline: I have not heard of that practice before. I agree that your approach is better for routine data types like dates and integers, at least for SQL Server. This is probably less of an issue on other data warehouse platforms. But on SQL Server, you'll see many improvements from choosing data types that are specific and appropriate for the data stored within.