October 20, 2011 at 5:54 am
Dear All,
Please ensure me about this subject. How many total records we can put in a table in sql server 2005.
This is urgent for me. I am developer.
Regards,
Sachin.
October 20, 2011 at 6:05 am
There is no limit other than the availbale storage space.
http://msdn.microsoft.com/en-us/library/ms143432.aspx
[font="Verdana"]Markus Bohse[/font]
October 20, 2011 at 6:20 am
There is no limit other than the availbale storage space.
-------------------------------------------------------
Hi,
Actually I have currently more than 10 lacs records in my table ok!!! In future within a year it will grow by 70 lacs i.e, total 80 lacs records then my searching on this table will be gradually slow day by day.
After 10 years table have more than billions records......then what about searching on the table ? may be searching will hang....
So i would like to know..what action i will take when table contain more than billion records.
I can not split the records in two different table because in this situation my programming code will not work.
Regards,
Sachin.
October 20, 2011 at 6:26 am
Hope below links suffice
http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx
http://qa.sqlservercentral.com/Forums/Topic414210-338-1.aspx
- Win.
Cheers,
- Win.
" Have a great day "
October 20, 2011 at 6:29 am
Phone compagnies get Millions of new records daily. So do banks.
It's all about architecture and really knowing your stuff. Nothing to do with sql server limits.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply