[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

At 12:01 PM 30/06/2004 -0500, you wrote:
>Date: Wed, 30 Jun 2004 11:21:12 -0400
>From: Francis Harvey <HARVEYF1 at WESTAT.com>
>Subject: RE: [dba-SQLServer] Difference between views and queries
>To: "'dba-sqlserver at databaseadvisors.com'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID:
>         <446DDE75CFC7E1438061462F85557B0F0481E931 at remail2.westat.com>
>Content-Type: text/plain
>
>Arthur,
>
>More often than not?
>
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf
> > Of Arthur Fuller
> > Sent: Friday, June 25, 2004 4:23 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: RE: [dba-SQLServer] Difference between views and queries
> >
> >
> > 1. I haven't yet seen a case where dynamic SQL is necessary. All it
> > takes to avoid it is one or more well-constructed sprocs, IMO.
>
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf
> > Of Arthur Fuller
> > Sent: Tuesday, June 29, 2004 8:19 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: RE: [dba-SQLServer] Difference between views and queries
> >
><snip>
>
> > I think dynamic SQL is for the lazy. So there, I said it.
>
>You really would characterize your responses as that balanced? I find
>your current restatement far more agreeable. Of course, I could add
>similar comments about people who's databases aren't fully normalized.
>Most of the time it is due to laziness and causes inefficiency and
>requires greater coding. Yet, sometimes it is necessary. Would you
>then make those same statements from above about everyone whose database
>isn't fully normalized? I would think you would at least be curious as
>to why it was done before making such blanket statements.