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