how do i figure the size of a database

[TechBoyJK]

I'm looking at SQL 2005 express, and it has a max database size of 4GB. My tables, on a rough average, have 25 columns with varchar/100.

 

[KB]

Are you asking for the initial size or for the total size over time?

If initial size, just set it to 10 MBs and set it to auto grow 10%.


For total size over time:

That isn't an easy question to answer, as varchars are variable (can be any size), so it all depends on the amount of data you are using and how many rows you plan to hld onto.

But lets assume you are using all of the characters in each column:

25 columns * 100 characters * 2 bytes per unicode character = 5000 bytes per row

DB size is roughly = X (number of tables) x Y number of rows + Z (size of structure of tables)

 

[Shuxclams]

Originally posted by: TechBoyJK
I'm looking at SQL 2005 express, and it has a max database size of 4GB. My tables, on a rough average, have 25 columns with varchar/100.

4GB on MSDE (SQL 2005 Express) is an absurd amount of information, especially it is all VARCHAR, now if the was BLOB or MEDTEXT I could see hitting that size easily. Our MySQL db parses 4MB of information a day, but that is reporting 500 peoples work, purchase orders and pictures per a day for the past two years and we still arent anywhere close to 4GB. So if you are talking about tracking you MP3 collection, pr0n collection or whatever... 4GB is waaayyyyy more then you'll need.








SHUX