>>Hi,
>>
>>The main table of my app has about 70 fields (column in SQL Server). And I need to add 6 more fields. This table, for the largest customers is about 700,000 records/rows (in SQL Server) and will probably be 1,000,000 soon.
>>In your experience is this number of fields (about 80) too many for the table of this size? I just want to know if I am not "breaking" a good practice.
>>
>>TIA for you input.
>
>the true limit is the row size 8.060 bytes.
Thank you. How do you calculate it? (since some columns are Int and some are bit and some are decimal). Is there a formula for adding all columns?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
