I have 2 database servers, 1 is used locally by a website I maintain, the other is a server for a CMS/data warehouse which stores data internally for my company’s sales reps. I need to pull data from both, currently I’m using linked servers but this can be incredibly slow for some queries, for example: