[dba-SQLServer] Difference between views and queries

Shamil Salakhetdinov shamil at users.mns.ru
Thu Jul 1 15:24:32 CDT 2004


Francisco,

I meant mainly metadata-driven (middle-tier) components, which on-the
fly (recursively) build/execute SQL etc.etc. They are generic i.e. once
written for a given meta-model they don't need to be rewritten - just
augmented/extended...

Shamil

----- Original Message ----- 
From: "Francisco H Tapia" <my.lists at verizon.net>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, July 01, 2004 3:42 AM
Subject: Re: [dba-SQLServer] Difference between views and queries


> I hear what you're saying Shamil, but coding is coding at any layer.
So
> even with less resources, ie, .net or c# programmers, code must still
be
> altered even if not at the sql server, but at the gui or webservice
> layer.  These statements don't make as much sense to me as just
> modifying the logic at the source.
>
> coding w/ .net components in your sproc doesn't make them dynamic sql,
> it's like coding .COM objects in your sproc you can do it via sp_OAxxx
> but these are limited to sysadmin roles because of the major security
> risk involved.
>
> no offense either to you or to the article you posted, it's a good
> article, I just don't agree that column names justify dynamic sql.
> There are otherways of working output at the gui level if that is
ultra
> imporant.
>
> Shamil Salakhetdinov wrote On 6/30/2004 3:56 PM:
>
> >Arthur,
> >
> >Just a philosopical opinion/point of view:
> >
> >Database-centered programming for nowaday businesses are becoming
more
> >and more dynamic and constantly changing....
> >The SPs are like a "chiseled in stone" stuff.
> >And dynamic SQL is an amorphic matter, flexibly and smoothly adapting
to
> >constantly changing businesses and their business rules.
> >Please take into consideration this fact: "chiseled in stone"
DLL-Hell
> >producing COM interfaces are being substituted with .NET Framework
> >flexible architecture...
> >IMHO the similar tendence is starting to appear itself more and more
> >apparently in data(base) layer programming.
> >Here is why Application Roles (see BOL) were introduced.
> >Here is why Youkon will support smooth integration with C#/VB.NET/...
> >extended SPs which in turn will (I guess) work heavily with dynamic
> >SQL...
> >
> >And as far as I see metadata-based data access and data
> >integrity/business rules verification/support are also becoming more
and
> >more popular - and this is what is needed for the modern small and
> >middle size businesses: they urge for the broad automation of their
> >businesses because of economical and other reasons but they don't
have
> >enough resources to finance design and development and then constant
> >redesign and code rewriting/refactoring...
> >
> >And of course I'm not talking about "SPs must die" - as usual
solution
> >is somewhere in between and is a balance of many interests but for
sure
> >dynamic SQL's role isn't that  narrow as described in
>
>http://www.sqlservercentral.com/columnists/rmarda/whendynamicsqlisusefu
l_printversion.asp -
> >the fact is that most of these samples look obsolete because they can
be
> >rewritten IMO using UDFs, XML (OpenXML) - i.e.using SPs but without
EXEC
> >I think! :)
> >
> >Just my pair of roubles,
> >Sorry in advance if I did miss the subject of this thread,
> >Shamil
> >
> >--
> >e-mail: shamil at smsconsulting.spb.ru
> >Web:   http://smsconsulting.spb.ru/shamil_s
> >
> >----- Original Message ----- 
> >From: "Arthur Fuller" <artful at rogers.com>
> >To: <dba-sqlserver at databaseadvisors.com>
> >Sent: Wednesday, June 30, 2004 6:57 PM
> >Subject: RE: [dba-SQLServer] Difference between views and queries
> >
> >
> >
> >
> >>Good example, and good reasoning, and I agree that dynamic SQL is
> >>
> >>
> >never
> >
> >
> >>out of the question. What I intended to write is that more often
than
> >>not, dynamic SQL is the lazy way out of thinking carefully about
> >>
> >>
> >sprocs.
> >
> >
> >>Most of the time it is unnecessary and costly in terms of
performance
> >>and front-end code; some of the time, there is no other way.
> >>
> >>Arthur
> >>
>
>
> -- 
> -Francisco
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>




More information about the dba-SQLServer mailing list