Max No of rows stored in a table. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Max No of rows stored in a table.

Hai all, I thought i should not post this question in the forum, however to clear
my doubt i am posting this in the forumn. Question is what is the max no of rows i can store in a table and what
is the max no of rows returned by a select statement. Is this has link
to DB Library?. I think there is no limit it store n no of rows i.e depends on the max
size of the db (in tera bytes).
Thanks in advance.
I agree with you. There is no restriction on the no. of rows / data in a table as long as the limits of SQL Server storage are not reached. Gaurav
The number of rows returned should depend on client query and individual data access technology (ADO,DB-Lib) settings. I believe that it is possible to return all (read Max) rows in a table in a single SELECT statement. What I don’t know is how long you would have to wait and the effect that would have on your server resources. Nathan H.O.
Max no. of rows is limited by storage in SQL server (at server end), I think no such value or specification for a limit. (BOL refers too) _________
Satya SKJ

I would hazard a guess to the contrary. <br /><br />Looking in sysindexes, the data type for rowcnt is a bigint.<br /><br />This places an implicit upper limit of 9,223,372,036,854,775,807 rows per table, something we’ll all lose sleep over, im sure <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
Hi all, Thanks for all ur views reg this question. Rushendra