Hi All,
I'm just wondering about what would be recommended width of a sql table (schema wise). By that I mean width calculated as
Code:
 select sum(max_length) from sys.columns where object_name(object_id) = 'MyTableName' and max_length > -1
The reason for my question is that I’m working upon recommendation from DBA department that no table should be wider than 1 KB. I got limited database development background, but according to my knowledge SQL Server 2005 should eat for a breakfast tables much wider that 1 KB. What also concerns me, as a person responsible for overall application design and delivery timeframes, that splitting one set of data between multiple tables (to stay compliance with 1 KB requirement) will increase the effort needed for development as I cannot re-use any existing tables/business layer objects.
Any comments on this would be greatly appreciated.
Thanks!