>Additionally, I'm amused that you can come up here and accuse me of spreading bad advice. I'm a student of such SQL authors as Ken Henderson, Itzik Ben-Gan, Joe Celko, Dan Sullivan, and Bob Beauchemin. So if you believe I'm spreading bad advice, then feel free to share that information with them, because you're essentially saying the same thing to them. Or better yet, as I've said before, venture from the safe confines of the UT and post your views on a SQL Server forum.

As far as I recall, Joe celko is not an advisor for SPs at all. BTW, I don't think his words are true all the time and I'm not that impressed with what he writes in columns (I read them regulary). I don't know from the others, but I defenately know that you have to ask the right questions to gain knowledge. Just saying that you're a SQL student actually means you still have got to learn a lot in this respect. I've graduated on this very same topic some 10 years ago.

I've been on the SQL server forum before, but essentially I don't feel much use of being there. SQL is my first language even before VFP. SQL is my specialty.

I know the feeling of getting burned to the ground when I had to defense myself to about the whole UT when I said that DELETED() tags did not speed up regular queries. I was badly outnumbered, but guess who was right ??? I'm I exceptional ?? No, There are a few people up here who are willing to go at the detail level to see how things are working from there they are able to place that into a bigger picture at the 10.000 foot level. Of course they will be attacked (there is one other guy up here suffering from the same, but despite his poor english he made it to MVP). You're stuck in habits and clichés. If you find something that works, you tell the world, but after that you're not willing to accept different and wider viewpoints.


I've seen too many SQL and database guru. They all disagree with eachother on certain areas. Remeber Codd and Date? Read it and draw your conclusions. Remember how Celko does disagrees with date? Again you have a brain. You're allowed to think for yourself rather than to blindly accept general wisdom. Do it.

And if you do, give me the arguments that makes a strong case for using SPs as a starting point.
I have not seen any...

You and others have been spreading bad advice on a number of occasions, just rehashing what someone else has said or thinks without a current factual basis, not able to get the right arguments that proves your case. This advice of using SPs is just another one. Esspecially for VFP developpers who have the right tool to do it differently, more efficient, this is harmfull. Remote views, parameterized queries, business layers, cursor adapters, local database engine for post processing are tools that are very strong and no other product can compare with that. In these cases, it justifies to realy rethink about better ways to do it, without cluttering your database with additional SPs that for the most part only have disadvantages.

Walter,