Hi Dave,
>which method results in better query performance ?
>
>Remote views or SQL pass through?
The answers may vary on this one. I don't think there is much difference speedwise, though you might get a slight advantage when using passthrough to retrieve data.
>which method gives better batch update performance ?
It will be nearly the same but views will provide more flexibility for manupulating data. If you are looking for large batch updates consider looking at BCP.
>if i send a query through SQL pass through does the SQL syntax have to be in the server's SQL syntax or in VFP SQL-Select syntax ?
Server's
>do i have to learn the SQL syntax of SQL Server 6.5 if i use SQL pass through to access its data ?
Yes. Its very similar though but you could do a lot more with SQL Server.