>What I see happening is one of 2 things. Either the remote view pushes the SQL code through (including the filter), and SQL does the work sending back only the 1 or so records - that'd be great.
>OR-- the remote view pulls the whole database info over, and then does the filtering locally (bad).

Dustin,

The entire job is done on SQLServer and only the result is send back the wire, ie no local filtering.