Calculating datatype limits i.e. SMALLINT - If SMALLINT is used to defined a user ID, how many users can populate a database before the limit for a table has been reached?
Posted on 2008-06-16
Just as the question states, we have been using SMALLINT to define USER IDs throught our schema. The concern has been raised that unless the schema is changed so that USER IDs are of type INT, we will exceed capacity.
1) How does it become obvious that available space will be in danger? Are we talking about the risk for one particular table (i.e. CompanyUsers) or does this mean there is a risk in every table that contains the USER ID?
2) How do I go about calculating the amount of space available to show exactly where the database stands?