[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