But why updating on a clustered index would cause a lot of page splitting and updating on a non-clustered index does not? The field has a varchar data type...

The plan also shows a split operation, where update is divided into delete and insert.  Can this be a problem if all indexes have 100% fill factor or should it...

This is transactional replication...  And this is all about MS SQL 2000 Ent Ed + sp3...

Just the same problem...  The only difference is that I upgraded from 32bit MS SQL2000 to 64bit version...

There is no disk compression.  Cluster size is 64k on both mirrors.

Noone ever tried to use this feature in Yukon?

2Frank Kalis:

The article tells:

--------------------------------------------------------------------------------

"By placing all of your temporary table creation statements together,

SQL Server can create plans for those temporary tables when one of them

is referenced for the...

Thanks, just found it:

IF (SELECT enabled FROM msdb..sysjobs(nolock) WHERE name = '[Job Name]')=0

PRINT 'OK'

ELSE PRINT 'Job [Job Name] is NOT disabled'

Just found a couple of SPs and wonder if this will work:

1. You create a publication with N - articles

2. Subscribe all servers that need at least one article from...

quote:

---

the databases must have the same collation between the publisher and the subscriber.

Change the collarion with :

ALTER DATABASE DBName

SET COLLATE SQL_Latin1_General_CP1251_CS_AS

---