Billy Pang
tuxedo_man at hotmail.com
Wed Jun 30 15:37:49 CDT 2004
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 > >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. > > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > _________________________________________________________________ Free yourself from those irritating pop-up ads with MSn Premium. Get 2months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines