[dba-SQLServer] Views

Martin Reid mwp.reid at qub.ac.uk
Wed Oct 8 14:44:53 CDT 2008


Susan

This gives you a good idea of what Access does

http://msdn.microsoft.com/en-us/library/bb188204.aspx

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 James Barash [James at fcidms.com]
Sent: 08 October 2008 20:04
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] Views

Sorry to jump in in the middle but I have done some testing using Selects
from Views with Where clauses using pass-though queries in Access and, at
least in that case, the filtering is done on the SQL Server and only the
results are passed back to the client. The problem is you need to modify the
SQL of the query to change the where clause.
The way I tested this was to run the SQL Profiler on the Server and then
open the query in Access. That way you can see exactly what the SQL Server
is executing.
I use Access to run reports against SQL Server and found this works pretty
well. I also use stored procedures the same way if I need more complicated
queries or need to manipulate the data for the reports.

James Barash


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Wednesday, October 08, 2008 1:15 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Views

That is my understanding of the documentation, Susan. The view pulls
everything to the client, which then filters out everything not interesting.
I could be wrong about this but it would be relatively easy to generate a
test. Unfortunately, today I have lots of work on my plate, but by tomorrow
I will have a 50M row table on which to test this hypothesis.

A.

On Wed, Oct 8, 2008 at 2:03 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> > SELECT * FROM MyView WHERE PK = 124
> >
> > results in the case of a view that all rows in the view are sent to the
> > client and then the client filters the result set.
>
> =======Arthur, I'm not sure I understand -- are you saying that if MyView
> contains 100 records but only 2 that satisfy the WHERE clause, the view
> still pulls all 100 records but only displays 2?
>
> Susan H.
>
_______________________________________________
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




More information about the dba-SQLServer mailing list