[dba-SQLServer] Difference between views and queries

Francisco,

I think you might have invented a whole new debating technique.
Probably not, but it is novel too me. Labeling someone's post a
figment because you apparently don't want to remember it. Oh, never
mind. I guess I'll treat this as a fair request anyway. Here is the
second repeat on my part.

* -----Original Message-----
* From: dba-sqlserver-bounces at databaseadvisors.com 
* [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
* Of Francis Harvey
* Sent: Tuesday, June 29, 2004 1:22 PM
* To: 'dba-sqlserver at databaseadvisors.com'
* Subject: RE: [dba-SQLServer] Difference between views and queries
* 
* 
* Francisco,
* 
* Francis Harvey wrote On 6/25/2004 2:24 PM:
* 
* >Do some research on the basic solutions for SQL that has to 
* adjust for
* >varying databases, conditions (dynamic search), or servers (different
* >SQL dialects). Some designs also call for encapsulating 
* business logic
* >outside of the data tier. In these situations, dynamic SQL is often
* >the only logical choice. I have only had to deal with dynamic search
* >myself, but this is enough to convince me of its usefulness.
* 
* Basically, some of them aren't really up for debate. If you need your
* business logic outside of your data tier for business or performance
* reasons, then it isn't a programming choice anymore. Similarly, I
* would think with needing to speak more than one SQL language in terms
* of maintenance or design considerations.

Let's call the last repeat a figment of email. I hope this is enough
effort for you.

Okay, this has to stop, just for my sanity. Look up straw man
argument. Show me where I provided an example for debate. I didn't.
That is the whole point of your irritation. Mine is that I won't do
it because I think I will have to cover ground that is better
researched on your own. It will give you a fairer and more complete
picture if you don't rely on me to provide the information, and it
would certainly save time if you would just do it.

I have now provided my search terms three times with many additional
repeats provided as you and Arthur requote my posts. I don't know why
keep complaining. I want you to have them. I want you to come back
with stinging rebukes for any of the problems listed. I just don't
want to do a tutorial.

Francis R Harvey III
WB 303, (301)294-3952
harveyf1 at westat.com


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Francisco H Tapia
> Sent: Wednesday, June 30, 2004 10:43 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Difference between views and queries
> 
> 
> Francis,
>     Let's not stray from the thread which was debating on Security 
> (additively, even though I know you disagree w/ the term 
> [this includes 
> non-additive properties such as DENY rights]) and Dynamic vs Static 
> SQL.  The proposed "search terms" as you put are a figment of your 
> imagination.  I've asked you to re-post your keywords you wish for me 
> search on, but you've simply negated, stating that you do not 
> have the 
> energy/time to do so. Fine, I'm not pushing you on that, however you 
> keep insisting that no one wants to do any research, and yet you do 
> nothing as well.  Hmm.. talk about a straw man argument there :). 
> 
> It is obvious you like to have in the last word edgewise, and so I 
> expect you to reply, however I ask you NOT to stray from the topic 
> thread, this list is about SQL Server topics, not who has not 
> done any 
> research, ie, it's the dba-SqlServer list not the dba-ResearchTopics 
> list.  Please DO NOT post another request for people to do the said 
> research and then call them lazy, when you refuse to do the 
> same.  I'd 
> say that's the pot calling the tea-kettle black.
<snip>