[dba-SQLServer] Difference between views and queries

Elam, Debbie DElam at jenkens.com
Fri Jun 11 08:13:04 CDT 2004


Just the opposite, I have always tried to harness the greater computing
power on the server and drag less data across the wire which is a
performance plus.  Views also have security independent of tables.  I have a
much better control of what data is editable and when by what view I use.

Debbie

-----Original Message-----
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

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of jwcolby
Sent: Thursday, June 10, 2004 9:33 AM
To: SQLServer
Subject: [dba-SQLServer] Difference between views and queries


Can anyone explain the difference between a view and a query?  Views use a
query, plus the view keyword.  I have a couple of books that I have read the
chapter on Views, but I so far haven't managed to "get" why you wouldn't
just use the query itself instead of turning it into a view.


John W. Colby
www.ColbyConsulting.com


_______________________________________________
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
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.



More information about the dba-SQLServer mailing list