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

Robert L. Stewart rl_stewart at highstream.net
Thu Jul 1 10:47:42 CDT 2004


I made the assumption that we were talking about databases that were 
transactional and should be normalized.

At 07:08 PM 30/06/2004 -0500, you wrote:
>Date: Wed, 30 Jun 2004 20:37:49 +0000
>From: "Billy Pang" <tuxedo_man at hotmail.com>
>Subject: RE: [dba-SQLServer] Re: Difference between views and queries
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <BAY1-F33SDPAJESuTei00017ebb at hotmail.com>
>Content-Type: text/plain; format=flowed
>
>A database could be not normalized for reporting reasons, isn't that true?
>difference between OLTP and OLAP?
>
>Billy
>
>
> >From: "Robert L. Stewart" <rl_stewart at highstream.net>
> >Reply-To: dba-sqlserver at databaseadvisors.com
> >To: dba-sqlserver at databaseadvisors.com
> >Subject: [dba-SQLServer] Re: Difference between views and queries
> >Date: Wed, 30 Jun 2004 12:17:41 -0500
> >
> >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
> >





More information about the dba-SQLServer mailing list