If your local tables have "little" data you may want to specify "REMOTE" when doing the join so that it happens on the server with large tables.

-Noel

It could also be that it is changing a lot of data and stats/fragmentation is getting worse and worse...

The definition of what is the batch doing is critical to give...

The use of a "central" table to get_nextID is not that hard and is "portable". Of course it will never get closer to the simplicity of an identity column.

I...

you can create a UDF to parse a string then use it on the SELECT list.

GSquared (6/3/2008)

---

Michael Earl (6/2/2008)

---

If this is a total re-design, why wouldn't you just create a single database that included composite keys in the tables - one of the key fields...

Ok here we go:

If you happen to use the replica for "failover" you will have to "update" the status of your identity columns.

If you use triggers that insert from...

radu.poenaru (6/2/2008)

---

I have this update SQL :

UPDATE Table SET [Status]=1 WHERE CCID=@CCID

where CCID is the primary key, but the PK index is non-clustered, I have another clustered index because...

hnguye21 (6/3/2008)

---

I want to know how to write a case statement that does an average of two tables.

Here is an example:

"CASE When online > 0 then online else student end"

where...

Paul (6/3/2008)

---

Hi,

Use identity, replication is much more mature than your own procedures of creating an unique number probably will ever be (no disrespect intended).

If you are not looking for a...

Tomm Carr (6/3/2008)

---

This solution gets my vote. If you have the same code then...

Paul (6/3/2008)

---

Hi,

Assume there is a after insert trigger on a table named tbl_persons. In that trigger - among all kind of other interesting things - a record is inserted in...

Run this at subscriber database.

exec sp_MSenumsubscriptions @subscription_type = 'both'

That...

You can "see" the latecy ( P-D and D-S) by using the TracerTokens in Replication monitor.

I manage a TON of publications. I totally agree that Replication Monitor is one of the worst pieces of software ( for lack of better words 😉 ) that I...