General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only