row limit | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

row limit

Hi, My company has sql server tables that have many, many small rows. Is there any effective limit to the number of rows in a sql table? I think there is only a limit to table size, not the number of rows, correct? Thanks.
Its funny to think about why do have this doubt. The Rowcount is limited by storage in SQL Server and fairly competing with other RDBMS in market. 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.
Ok, so as long as I have the storage space I’m ok. If you are asking why I’m having doubts it’s because I have literally billions of rows. Thanks.
You’re right. A single row cannot be wider than 8060 bytes. As for number of rows, there is an intersting chapter in BOL called "Maximum capacity specifications". There you find what Satya already mentioned. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Don’t get me wrong about my first reply, you will get more in-depth information as referred by Frank.
As long as the hardware is supported and compatible storage is used then SQL server can cope the load… size doesn’t matter. 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.
This might turn out interesting for you:
http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx Overread in my first reply that you’re dealing with that much rows. I think, I don’t tell you anything news when I say, that in such a case almost everything is important. DB design, application design, hardware… What data volume are we talking about? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

]]>