Yes. Create parameterized remote views so that you only get the data you are interested in.

>> 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)?