SQL Server Performance Forum – Threads Archive
Max number of rows
Does anyone number the maximum number of rows a SQL Server DB can have? I have this question for SQL Server 2000 and SQL Server 2005. We are looking at moving an Oracle DB to SQL Server and the DB has over 600 million rows. Thanks, SKAccording to books online there is no limit imposed by sql. It is: "Limited by available storage". Check for the subject "maximum SQL Server capacities" in sql books online for the specific limits.
even ive the feeling that max no of rows a table can have depends on available storage in sql 2k.
True, I don’t see any issue in managing "600 million" rows when using SQL Server 2000 and it will be more managable when full version of 2005 will be used. I have no grudge against Oracle but in my experience SQL can handle the show if the application is designed properly and database optimization is maintained reguarly. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The raw number of rows is pretty much handable. However, in your case other aspects become evident, as such design, indexing, hardware …
Anyway, here are some links
http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp
http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp
http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp
—
Frank
http://www.insidesql.de
… and this website for lots of goodies & tips in terms of performance gain. [8D] Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
You may consider horizontally partitioning that table. Much better supported by mssql 2005.
Thanks for the info sk
]]>