Full-Text search row limit

Hi,
This question is for all group, but particulary to Hillary Cotter, in
relation to one article published in msdn
(http://msdn.microsoft.com/library/de...tml/sp04f9.asp).
Hillary, in this article, you explain that the new Full-text search engine,
in SQL Server 2005, can index up to 2 billion rows and the limit on SQL 2000
was between three and 30 million rows.
I think that I don't understand you. Is that the limit in SQL Server 2000?
30 millions rows?
Thanks in advanced to Hillary and all newsgroup.
qwalgrande
AFAIK there is no hard limit for SQL 2000, rather performance declines when
you start to get that high. I got the 30,000,000 statistic from MS, let me
try to dig it up and provide you with the link.
Hilary
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:F424BC6C-CC52-4582-8D01-80C0908F1F6B@.microsoft.com...
> Hi,
> This question is for all group, but particulary to Hillary Cotter, in
> relation to one article published in msdn
> (http://msdn.microsoft.com/library/de...tml/sp04f9.asp).
> Hillary, in this article, you explain that the new Full-text search
> engine,
> in SQL Server 2005, can index up to 2 billion rows and the limit on SQL
> 2000
> was between three and 30 million rows.
> I think that I don't understand you. Is that the limit in SQL Server 2000?
> 30 millions rows?
> Thanks in advanced to Hillary and all newsgroup.
> --
> qwalgrande
|||qwalgrande,
Actually, no upper limit has ever been made public by Microsoft for SQL
Server 7.0 or SQL Server 2000 Full-text Indexing functionality. While at
Microsoft, I worked directly with a SQL Server 7.0 Full-text Indexing
customer who with my help, successfully FT Indexed a table with 64 million
rows. Although, SQL Server 2000 was tested to 20 million rows, I have worked
regularly with customers and clients who have successfully FT Indexed more
than 30 million rows table.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:F424BC6C-CC52-4582-8D01-80C0908F1F6B@.microsoft.com...
> Hi,
> This question is for all group, but particulary to Hillary Cotter, in
> relation to one article published in msdn
>
(http://msdn.microsoft.com/library/de...-us/dnsqlpro04
/html/sp04f9.asp).
> Hillary, in this article, you explain that the new Full-text search
engine,
> in SQL Server 2005, can index up to 2 billion rows and the limit on SQL
2000
> was between three and 30 million rows.
> I think that I don't understand you. Is that the limit in SQL Server 2000?
> 30 millions rows?
> Thanks in advanced to Hillary and all newsgroup.
> --
> qwalgrande
|||Thanks to both.
qwalgrande
"John Kane" wrote:

> qwalgrande,
> Actually, no upper limit has ever been made public by Microsoft for SQL
> Server 7.0 or SQL Server 2000 Full-text Indexing functionality. While at
> Microsoft, I worked directly with a SQL Server 7.0 Full-text Indexing
> customer who with my help, successfully FT Indexed a table with 64 million
> rows. Although, SQL Server 2000 was tested to 20 million rows, I have worked
> regularly with customers and clients who have successfully FT Indexed more
> than 30 million rows table.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
> news:F424BC6C-CC52-4582-8D01-80C0908F1F6B@.microsoft.com...
> (http://msdn.microsoft.com/library/de...-us/dnsqlpro04
> /html/sp04f9.asp).
> engine,
> 2000
>
>