Estimate physical space for SQL Server database

[jieyin]

Hi, do you have tips on allocating space in SQL Server for a database to accommodate about 9,000,000 records and 3,000 fields (divided in multiple tables of course)? How much space do you recommend? Is there a formula to calculate physical space for any given table size (say 1,200,000 x 50)?

Thanks

 

[JayKusch]

Tought to estimate that one. It all depends on the diffrent data types that are used and in some cases, ie Varchars and Chars, depends on how large they are defined. Then you must also consider indexes that will be present.

Thanks

J. Kusch