Arthur Fuller
artful at rogers.com
Wed Jun 30 19:08:30 CDT 2004
Yes, Billy! Big difference between OLTP and OLAP systems. In short, don't consume CPU cycles etc. on the OLTP system; write a separate OLAP system that contains nothing but serious reports, so as not to slow the OLTP system down when some manager wants some report. In this case (OLAP) it is most often correct to denormalize. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy Pang Sent: Wednesday, June 30, 2004 4:38 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Re: Difference between views and queries 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com