Of what? Databases, Tables or Indexes?

Most of the caches are global in nature. Your performance affects and is affected by all other usages on the server.

Yes, it is caching. There are lots of different kinds going on.

You can control it with the following commands:

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

If performance of this code:

Insert into propbut_pr (..., SCODE, ...)

Select ...

, '!' + Right(Cast( (Select Max(Cast(Substring(p2.SCODE, 2,12) as int))

...

jim.powers (7/24/2008)

---

rbarryyoung (7/23/2008)

---

Well I don't have enough details to do anything exact, but assuming that they are only using 5 digits in that Varchar(12) field, then something like this ought...

Don't worry about it, western civilization got along without it for several thousand years......

Great! Glad it worked out.

hmmm (scratches head) I guess I missed that transactional replication was involved.:ermm:

Entirely possible. I believe that something changed from 2000 to 2005 in...

It is, but in different places. You sort of have to put it together.

The key to another way to view it is to remember two facts: 1) CASE is...

Jeff Moden (7/23/2008)

---

Does transactional replication replicate TRUNCATEs? If yes, then I have to eat a fair bit of crow and say you are correct on all 3. :blush: ...

Yes, it is trying to convert everything to int, and it is fine as long as that works.

I agree, you should Cast/Convert evrything to the same data type.

The problem is that you are trying to use the CASE function to dynamically switch what data type it is returning and you cannot do that. All of the...

Glad I could help.

Hmmm, I'm pretty sure that would be 36.