Re: Because you guys/gals/girls/women/insert pc term here are a smart lot

Richard Heyes wrote: >>> it' may seem like a small amount of space but when you have 8 >>> char(255) columns in a table with 10 million rows you'd noticed the >>> difference considerably. >>> > > It is a small amount of space. Perhaps it was necessary in the days > when 1Gb Hdds were a luxury, but those days are long gone. In the > example you gave you're still only wasting approx 1 GB. Hardly a lot > these days when you consider you buy a consumer 500Gb Hdd for £50. > > You also have to remember that server drives are more expensive as they are of higher quality than consumer disks. They require a lot more MTBF than your normal hard drive at your local computer store. Also, if you waste 1GB in 1 column, imagine how much wasted space there is in the whole DB. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com