How many records mostly can a table has?

Hi:
In SQL Server 2000, how many records a table can have at most? I need to
create a table in that there are 3 fields: one is identity int (a key), one
is varchar(18) and another is bit.But I am not sure if I can store 10424128
records in a table? Is it too big? If not, or not good, any idea to handle
big records?
Thanks
Q.>> But I am not sure if I can store 10424128 records in a table? Is it too
There is no documented limit on the number of rows in a table. Merely a
million rows, is not a big deal at all.
However, if this table is well thought out, you might want to include a
UNIQUE NOT NULL constraint on the VARCHAR(18) column or on a combination of
the VARCHAR(18) column and the bit column to prevent duplications.
Anith|||There is no set limit on the number of rows in a table. 100s of
millions of rows are very common. Your table is actually quite small in
total size so you shouldn't have a problem in principle, even on entry
level hardware.
As regards performance, that is affected by factors other than total
size, such as the number of concurrent users and the number, size and
type of transactions being performed.
David Portas
SQL Server MVP
--|||In your case specifically, the limit to your table will sure be 2,147,483,64
7
records. Because you have identity column that has int datatype. And thats
the limit of int datatype.
"Quentin Huo" wrote:

> Hi:
> In SQL Server 2000, how many records a table can have at most? I need to
> create a table in that there are 3 fields: one is identity int (a key), on
e
> is varchar(18) and another is bit.But I am not sure if I can store 1042412
8
> records in a table? Is it too big? If not, or not good, any idea to handle
> big records?
> Thanks
> Q.
>
>
>