Possible Duplicate:
What are the arguments against or for putting application logic in the database layer?
Assuming I got over the problem of maintainability and debugging.
My assumption is it is better to have all my queries as stored procedures.
Am I missing any caveat?