Estimating growth of mdf file size...

Hi, how can I estimate the mdf file size's growth as record inserted?

For a rough calculation you can calculate the sum of bytes needed for one row, e.g. Having a table with three CHAR(200) will need 600 bytes + additional overhead ~32 bytes. You can just sum up all the data types you have to get the row size in your table.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thank you for replying.

Then, what about the growth if the table has index column?|||You will have to add the size of the indexed columns in addition.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de