R
realityleak
Guest
Not particularly query efficiency, more like storage space efficiency. If I was going to design a SQL database like that I would be using VARCHAR(MAX) field sizes which would increase my file size because of the memory each field would use. If you have ever seen the number of columns in any of the datasets that exist in the NHS, you would realise why sometimes limits in SQL Server have to be set. Integration with other DB systems is also more problematic if the DB is saying one thing but the data is saying another. Still, Who's counting. They all have their place. Thanks for the help you all gave earlier and sorry if I have started any arguments 
Continue reading...
Continue reading...