471,573 Members | 1,146 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

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 1184
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
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.