|
TG
Flowing Fount of Yak Knowledge
USA
5467 Posts |
 Posted - 03/08/2013 : 10:25:12
|
Books online offers precise formulas for estimating table size. However, your post raises several red flags:
application design - do the number of columns in your table actually "grow" over time? Typically this is not a good design. Again, generally speaking, you want to move towards narrow tables with lots of rows. You can usually add another attribute (column) that would qualify what type of row that represents rather than a new set of columns.
database design - large number of columns CAN indicate a poorly designed model. And of course a bad model will lead to awkward t-sql and performance problems.
But that link will answer your question as to estimating table size.
Be One with the Optimizer
TG |
 |
|
Effect of number of coulms on table space
