Size limit on a SQL 7 server 1

[srajeevkumar]

Hello,

If I were to update SQL 7 Database table which has 25 fields ( each field has an approx size of 40 charactors) with 13000 records per day. How long will my SQL 7 server will be able to handle the table and the tables size. Any suggestions or any thoughts or help on this please.

Rgds

Rajeev

 

[JayKusch]

Hmmm... I beleive the max number of rows your table can have is really determined by how much disc space is available for growth. I know we have a history table of probability measures here w/ over 5.5 trillion records and still growing.

At your rate, you would hit our table size of 5.5 trillio around 1.1 million years from now !!!

(5.5t / 13,000) / 365

Thanks

J. Kusch

 

[srajeevkumar]

Thanks very much for the reply.
I feel reassured and confident now that I will have no problems as long as I have decent disk space. To hold 1 million records in a table with such a structure , how mch disk space does one need.

Rgds

Rajeev

 

[SemperFiDownUnda]

formulas are pretty straight forward
# of Rows * AvgLen of row.

Make sure you pay attention to the fill factor and compute that in. Any indexes you need need to be computed to. This can be a little more complicated because of the Btree structure of the index and is dependent on the key size.

1 million records is really nothing ~40 meg.

check out

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

for SQL server limits