jwcolby
jwcolby at colbyconsulting.com
Fri Jun 11 08:47:09 CDT 2004
>I am glad I am not one of your customers. I prefer performance. LOL. Be nice Robert. John W. Colby www.ColbyConsulting.com -----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 9: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