[dba-SQLServer] Views

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