469,097 Members | 1,494 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

Storing records

164 100+
Hi all.

I want to store about 300 crore records into sql server. Is it possible?

Whats the actual memory capacity of sql server for storing records..?

How many max amount of records can I able to store?

Plz let me know immediately

Thanx
Apr 9 '07 #1
6 1140
iburyak
1,017 Expert 512MB
The size is limited only by capability of your computer.

300 records is nothing for SQL server it equipped to process millions of records with no problem in seconds.

Hope I answered your question.
Apr 9 '07 #2
arunbalait
164 100+
Ya fine...

But I asked for more than crores of records.

Can i store more than 300 crores of records if my computer has enough memory???

Will any memory or cyclic redundancy problem occur?]

Thank you...
Apr 9 '07 #3
iburyak
1,017 Expert 512MB
For exact numbers read this:

http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx

or

http://www.sqlservercentral.com/columnists/sjones/maximumcapacityspecificationsinsqlserver2005.asp


Depend on server you have.
Apr 9 '07 #4
arunbalait
164 100+
I already gone through those links. In those links its mentioned all about the capacity of tables, procedures, datatypes etc., but I want exact size of inserting records or size of a table according to number of records..

Thanx for your replies
Apr 9 '07 #5
iburyak
1,017 Expert 512MB
I already gone through those links. In those links its mentioned all about the capacity of tables, procedures, datatypes etc., but I want exact size of inserting records or size of a table according to number of records..

Thanx for your replies

This is what it says in those links isn't it what you wanted to find?

[PHP]Rows per table Limited by available storage [/PHP]

I assume by number of records it is a datacenter and according to these links you need up to 32 CPU to process such large sized data.

Good Luck.
Apr 9 '07 #6
arunbalait
164 100+
Oh.. Thanx 4 ur informations..
Apr 11 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by hamvil79 | last post: by
6 posts views Thread by Kieran Benton | last post: by
9 posts views Thread by Brad | last post: by
3 posts views Thread by ArmsTom | last post: by
1 post views Thread by webcm123 | last post: by
6 posts views Thread by Lint Radley | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.