I have been watching this conversation about COBOL - and I find it to be rather funny.  I started working in this industry on a little known platform called...

And this is part of what I am talking about...

I vaguely remember COBOL from early in my career. I didn't think much of it as a language then, even though I was working in C/C++/Pascal. Of course, I...

As I said it would not surprise me if they have continued to try and create a...

Try changing the left join on "bar" to this:

LEFT JOIN (SELECT 
               ...

That sounds about right.  The...

Still if I am going to use code to process data manipulation with a need for speed I am going to use a compiled language (C, C++, Java,...

That sounds about right.  The number of...

Break it into multiple publications/subscriptions/snapshots.

You could do something like a subscription for lookup tables, another for payables, etc. etc

When I did the failover to secondary. I had database was recovering on former primary, but it was very slow taking longer. If that is the case then you...

Yes, I did

I submitted a few sessions, got accepted, and realized that I had a conflict that weekend!!!!!!!!!!!!!!

I’m even more confused.

Are you attempting to do a DR test?

Are these physical or virtual machines? If they are virtual, fail it over, shut off the node 1 server, and...

As I understand it, you want to fail over to a secondary, but you want to prevent the transactions from syncing back to the former primary(now secondary) while work is...

What are you trying to accomplish?  If you want a read-only secondary server for reporting, then there are multiple technologies in SQL that you can leverage.  Availability Groups and replication...