Thread resuscitation time ...

Anyone else using Wherescape red? I've got the same questions as the OP, any comments appreciated.

Thanks

Solved. I got this back from microsoft, there were problems with the RML file as the readtrace hadn't succeeded.

11/10/11 11:07:58.620 [0x0000BDAC] REPLAY ERROR: Total users value 0 outside valid...

Something else I recently learned that I left out of the article for clarity is about duplicate keys in the source data.

MERGE gets broken horribly if there are duplicate...

Matthew-399425 (11/4/2010)

---

Question though- why is the IDENTITY column of the type an INT, while the @single_update_id param to the proc is a BIGINT? I am guess the two datatypes should...

vishal.gamji (11/2/2010)

---

What are your views on using this kind of logic in an ETL flow for slowly changing dimensions - overkill?. What about the performance implications when it goes into...

R.P.Rozema (11/2/2010)

---

Good article, thank you!

One addition though: if your procedure is called from within a trigger or from a service broker handler, most likely the catch block won't be called...

Performance on the error free "fast path" is great and I'm easily pushing through merges of 10k rows. On the slow path when there are errors, performace is going to...