Hi we are trying to estimate the size of a sql server database so our admins can advise us of the size.
We would rather have the upper limit.
So we know number of rows - and the columns.
So I appreciate for the general table sizes it would be the maximum size the column could hold.
However we need something for indexs. ball park is fine.
If column ID was index..if I just doubled the size of column ID would that suffice? will the index size ever be larger than then the size of the column we are indexing?? if so I will use this as a guideline.