Can I use KB 303459 to increase FT performance in 2005 and 2008?

I notice that KB 303459 (http://support.microsoft.com/kb/303459/en-us)
increase the FT performance in SQL Server 2000 and previous versions. The
increase is accomplished only by a registry setting which is very easy to
achive. I am wondering if I can use this article in SQL Server 2005 or SQL
Server 2008 to improve the performance as well.
Many thanks!
Felix Jiang
No, consult this white paper for performance tweaks in SQL 2005!
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Felix_Jiang" <FelixJiang@.discussions.microsoft.com> wrote in message
news:53C15A1D-1D9C-4DD8-94EC-F95C814D2F9D@.microsoft.com...
>I notice that KB 303459 (http://support.microsoft.com/kb/303459/en-us)
> increase the FT performance in SQL Server 2000 and previous versions. The
> increase is accomplished only by a registry setting which is very easy to
> achive. I am wondering if I can use this article in SQL Server 2005 or SQL
> Server 2008 to improve the performance as well.
> Many thanks!
> Felix Jiang

Can I set a default range for the identity values for merge replication?

Hello,

We have a couple of tables that can have quite a bit of data each day prior to replication. Can we increase the default values for a table for each subscription? For example we have a table called table1 and on the sqlexpress client they could enter in 10000 rows a day, on table2 it's just 100 rows a day. How can we increase the values to where we do not get the error for table1 stating that the insert failed because it conflicted with the identity range check constraint. Thanks in advance.

Hi, John

If I understand correctly, you actually want to set different identityrange from different article. For example, table1 identity range is 10,000 and table2 with identity range is 1,000. You can set it through sp_addmergearticle with control values of @.identityrangemanagementoption, @.pub_identity_range, and @.identity_range.

BTW, you are not allowed to set different identity range for different subscriptions which subscribe to the same publication.

Hope these information will help.

Thanks

Yunjing