Came across this discussion and it fits in with a solution we are currently working in virtualizing the CDC process..

I have been asked if I can use CDC with a...

OK, so the follow-up question this would be:

How would MERGE perform inside an INSERT/UPDATE trigger?

Being that the inserted table would be the source, thus minimal rows, and the...

Interesting discussion, we have come across this recently and are looking for a solution.

Might just have to try this, though not too certain about the rollback for the disable...

.. ahh, well they didn't say when 😀

John,

Thanks for the article, interesting read. We had a similar item here not long ago for a customized report, and I had the developer create a dynamic Pivot statement to...

Good article, especially for beginners, but useful as a simple refresher.

We discuss joins quite often in optomizing code and it's amazing how many developers forget the basic rules.

Waiting for the...

Newbie here!!

I am currently evaluating SSRS for our company use as opposed to CR, and am very impressd by what I have seen thus far, and will be demonstrating it...