[dba-SQLServer] Views

Never mind Martin,

I have found your links useful as I have a client that we are 
converting to an SQL BE and I am working out whether to use an Access 
ADP, or mdb with ODBC links.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand

At 9/10/2008, you wrote:
>Susan
>
>Sorry I read you where looking at performance of Views with Access. 
>Its old age and to much SharePoint.
>
>Martin
>
>
>Martin WP Reid
>Information Services
>Queen's University
>Riddel Hall
>185 Stranmillis Road
>Belfast
>BT9 5EE
>Tel : 02890974465
>Email : mwp.reid at qub.ac.uk
>________________________________________
>From: dba-sqlserver-bounces at databaseadvisors.com 
>[dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan 
>Harkins [ssharkins at gmail.com]
>Sent: 08 October 2008 21:24
>To: Discussion concerning MS SQL Server
>Subject: Re: [dba-SQLServer] Views
>
>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:
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com