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

Francis Harvey HARVEYF1 at WESTAT.com
Sun Jul 11 15:15:40 CDT 2004


Robert,

Fine, I'll restrict myself to the members of this list, as these posts
in fact are. If someone posted a problem where it was obvious there
database was non-normalized, would you just issue a blanket statement
accusing them of being lazy or would you ask why? As we have just had
a locking issue post illustrating this situation, this is not just a
possible  scenario. I did suggest Mark might normalize his database,
but I didn't just assume it wasn't done because of laziness nor did I
issue a blanket condemnation. I find that to be the true laziness.
Just ask why, or if providing guidelines on proper database creation,
suggest there may be exceptions even if you don't list them.

Francis R Harvey III
WB 303, (301)294-3952
harveyf1 at westat.com


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Robert L. Stewart
> Sent: Wednesday, June 30, 2004 1:18 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Re: Difference between views and queries
> 
> 
> Francis,
> 
> Actually the reason most databases are not fully normalized is not 
> laziness, but ignorance.  Most DBA's know nothing about 
> normalization and 
> many developers even less.  And, yes I would make such a 
> blanket statement.
> 
> Robert
<snip>



More information about the dba-SQLServer mailing list