I have been reading up quite a bit on the topic of Stored Procedures (SPs) and keep coming across contradicting opinions from various 'SQL experts' on whether or not they should be used. Sometimes it's a downright 'No' (Frans Bouma's Blog for example -- google the term for the article), while at other times it is a strong 'Yes' (Rob Howard's blog). What reading those and a few more articles did was create more confusion on the topic. So I thought of putting up a question here to see what people around here think about SP.
The reason I began exploring SPs is because on my website, I need to run an update every few days/weeks that involves a series of complex calculations based on the data in the DB at the time. I believe the best way to do is to run a proc myself, rather than trust the user to remember to do it on the front-end (or through the use of a server-side script).