Problem

Change linked server collation to collation compatible

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_linked_servers.sql

Based on

https://blog.greglow.com/2025/05/18/sql-why-are-your-linked-servers-so-slow/