Why Rob Howard Rocks

Tuesday, November 18, 2003

I really don't need to say anything, this article speaks for itself. A must-read for anyone that does any database work whatsoever. The last sentence is the best analogy for not writing complex SQL that I have ever seen. A gem of a post... great job.

4 Comments

He's wrong in all arguments.

Stored procs aren't precompiled. He claims they are. So far for being well informed.

Frans Bouma - Tuesday, November 18, 2003 11:40:00 AM
Sorry Frans. I'm going to listen to Microsoft on the issue before I listen to you.

Robert McLaws - Tuesday, November 18, 2003 5:16:00 PM
> Stored procs aren't precompiled.

No, Frans is correct on that one -- although he's using it a bit out of context.

I was using Pre-Compiled or Cached to be interchangable. SQL sprocs are not compiled like Oracle sprocs which has the ability, if memory serves, to compile the sproc to C.

The rest of it, well. I guess you can say we have a difference of opinion / information.

Rob Howard - Tuesday, November 18, 2003 5:53:00 PM
" Sorry Frans. I'm going to listen to Microsoft on the issue before I listen to you."

That's of course your choice :)

Frans Bouma - Wednesday, November 19, 2003 3:07:00 PM

Comments have been disabled for this content.