SQL queries can be as efficient as stored procedures

For posterity, here’s the link. You have to write your queries carefully to minimize recompilation.