Can you tell us better what the data actually are for each user per month ?  ie. is your designed report displaying duplicates or actual rows ?   I think I...

Did this original poster ever find a suitable alternate solution to using these linked servers for her/his cases ?
I agree S/B would not be suitble solution, but am...

Would the transfer rate be approx 98 MB/sec ?  No idea what details you gave your vendor, but chances are it might be an [optimistic} estimate., since they may know...

An excellent article, Sir, and very important considerations.   Thank you !

I think it would depend on many factors, but the general rule I have known is to provision for what it available from your local carrier, with to best thru-put...

Thank you for this article and the series itself !
Historically, perhaps others have explored problems with interruptions / exceptions, err events, in mirror traffic described here.
Any "common-type"  problems,...