How to avoid constantly querying a server
Note you should include which SQL Server version you're using, as this will impact what answers are applicable to your use case.
If you're trying to alleviate pulling data across remote servers, then you should look into a data synchronization feature like Replication, AlwaysOn Availability Groups, or SISS
These can be used to synchronize the data from a remote server to a local server, so your querying can all be contained to one server.