> The problem is that every time you "USE" a remote view all rows from the SQL Server table will be copied over the network to your local machine.

Yes, but could I filter the data in my remote view?
Is that ok with such filter (for best performance)?