[AccessD] Access and SQL Server - Where is the work done - How Many Rows are Shipped Across the Network

Several different answers given.  Jim Dettman wins the prize for best answer :-)

-- 
Stuart

On 12 Mar 2013 at 11:12, Brad Marks wrote:

> All,
> 
> This is just a curiosity question.
> 
> Let's say that I have an Access application that obtains data from a SQL Server database via ODBC.
> 
> There are 1,000,000 rows in one of the SQL Server tables.
> 
> There is a query in the Access application that returns 100 rows from this table based on the "Where" condition in the query.
> 
> I would guess that the "heavy lifting" is being done by the SQL Server database box and only 100 rows are shipped back to the Access application on the PC.
> 
> Is this correct?
> 
> Is this always the case, or is it possible that all of the 1,000,000 rows are sent back to the Access application depending on the complexity of the SQL?
> 
> Again, these are just curiosity questions.
> 
> Thanks,
> Brad  
> 
> 
> 
>