SP not good all the time (Score 1)

At my work we write apps that are only used inhouse and app that are used by 1000+ users. Our applications are mostly data entry apps with a decent amount of reporting. We only use stored procedures in the software that we sell to our users because it makes it easier to implement any updates/fixes in code than it's in a stored procedure and just send them a program(executable) update. For inhouse we prefer stored procedures because maintenance/updatability is not a problem.

I think if you are looking at large databases where stored procedures may make a huge difference weigh your options between speed and ease of sending updates to the users.

Just my 0.02 cents.