How many records in a table?

[Martin Feuersteiner]

Hi! Stupid question as this also depends on hardware but is there a limit on
how many rows I can have in a single MSSQL 2000 table? Table consists of six
int columns and has three indexes. Is like 10 Million or 100 Million
considered to be 'normal' or unrealistic?

Thanks very much for your thoughts!

Martin

[Adam Machanic]

Re: How many records in a table?

Martin,

It's actually limited ONLY by hardware (disk space). I wouldn't say that 10
or 100 million are anywhere near "unrealisti c". Maybe 1 trillion would be
more like it!


"Martin Feuersteiner" <theintrepidfox @hotmail.com> wrote in message
news:cit9ft$m5b $1@hercules.bti nternet.com...[color=blue]
> Hi! Stupid question as this also depends on hardware but is there a limit[/color]
on[color=blue]
> how many rows I can have in a single MSSQL 2000 table? Table consists of[/color]
six[color=blue]
> int columns and has three indexes. Is like 10 Million or 100 Million
> considered to be 'normal' or unrealistic?
>
> Thanks very much for your thoughts!
>
> Martin
>
>[/color]

[Martin Feuersteiner]

Re: How many records in a table?

Thanks!

"Adam Machanic" <amachanic@hotm ail._removetoem ail_.com> wrote in message
news:4152361a$0 $2656$61fed72c@ news.rcn.com...[color=blue]
> Martin,
>
> It's actually limited ONLY by hardware (disk space). I wouldn't say that
> 10
> or 100 million are anywhere near "unrealisti c". Maybe 1 trillion would be
> more like it!
>[/color]