[dba-SQLServer] Views

Susan Harkins ssharkins at gmail.com
Wed Oct 8 15:24:41 CDT 2008


I'm totally missing your point I guess -- I'm working with views in SQL 
Server, Access has nothing to do with what I'm doing.

But... I'll drag out Profiler and see what it says. :)

Susan H.



>
> When data is queried remotely in Access, all of the data is returned to 
> the client, and any filtering and sorting is done on the client side. 
> Because SQL Server data is usually queried over a network from a client, 
> major network bandwidth issues can occur. Therefore, when moving your back 
> end to SQL Server, it is important to redesign your queries so as to 
> return only the required set of data to the client (rather than the whole 
> data set). For example, a query behind an Access form would be:




More information about the dba-SQLServer mailing list