[dba-SQLServer] Re: Difference between views and queries

Jim Lawrence (AccessD) accessd at shaw.ca
Fri Jun 11 13:48:38 CDT 2004


Robert:

Please refer to additional detail I provided, with other list comments. I
prefer performance too. :-)

Hope the additional comments clarify things.
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Robert
L. Stewart
Sent: Friday, June 11, 2004 6:38 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Re: Difference between views and queries


Jim,

I am glad I am not one of your customers.  I prefer performance.

Robert

At 08:20 AM 6/11/2004 -0500, you wrote:
>From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca]
>Sent: Thursday, June 10, 2004 2:07 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Difference between views and queries
>
>
>Hi John:
>
>Personally, I see little reason to run views as their creation is spawned
at
>the server side and any hit on the server I try to avoid. The concept of
>distributive computing has always appealed to me. Queries, run at the
client
>side.
>
>There might be better performance with views, if there are limited people
>accessing the server. Views limit, not that the client can see it anyway,
>access to/display of the real table and present a pseudo table. Security?
>
>HTH
>Jim


_______________________________________________
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