Re:Do you make these 5 database design mistakes?
by BrentOzar on Tuesday January 03, 2012 @08:54AM
(#3419608)
>> But, if you store a SSN as say 123-45-6789 your using at least 11 bytes to store a 4 byte number.
Plus it gets worse because people inevitably end up writing queries that parse the number with dashes, brackets, or other special delimiters. Those queries are CPU-intensive to do on the fly, and with databases like Oracle, DB2, and SQL Server charging by the CPU core, it becomes an expensive proposition as well.
Plus it gets worse because people inevitably end up writing queries that parse the number with dashes, brackets, or other special delimiters. Those queries are CPU-intensive to do on the fly, and with databases like Oracle, DB2, and SQL Server charging by the CPU core, it becomes an expensive proposition as well.