does it make a difference in performance (lot of updates) between two SQL Servers and the updates are happening through Linked Server.
Right now both servers are in the same network environment.
One is being proposed to be taken off-side (cloud environment-managed). In that scenario, does the performance expected as before when crossing over firewalls?
would appreciate your thoughts on this.
(one database is 12 GB and other 7GB data file size).