[dba-SQLServer] Views

Um... thank you... but I want to know what SQL Server does. :)

Susan H.


> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>