What is the best way to handle SQL Server data on a form, with a Remote View, or SQL Passthrough?

Also, when you use SQL Server in a Form's Grid control, how much of the data actually comes across the network to the workstation where the user is utilizing a VFP form? Does the data end up in the temp files, until saved and then altered on the SQL tables immediately or later, upon saving?

Cecil