[dba-SQLServer] Views

aaaah.... *ding* <lightbulb goes on>...  Now I understand perfectly :)

thanks

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


Hi Francisco,

Your last paragraph was precisely the point I was attempting to make,
however inelegantly I phrased it. We are in 100% agreement on this.

A.
>> btw, if the argument here is that you are linking a view directly to
access
then yes, all the data is sent to access and access further fileters the
results by adding the where clause there, however if you link the view as a
pass-through query, you loose nothing in performance by pre-filtering the
results at the sql engine instead of at access.

-Francisco
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.