title: Do Stored Procedures really boost performance in MS SQL / .NET?
body: <p>Jeff Atwood wrote about this <a href="https://blog.codinghorror.com/who-needs-stored-procedures-anyways/" rel="noreferrer">here</a>, and while I understand the theoretical performance boost a stored procedure could offer, it does seem like a tremendous pain.</p>
  
  <p>What types of queries would you see the most performance increase using stored procedures, and what types of queries would you rather just build on the fly?</p>
  
  <p>Any documentation one way or another would be greatly appreciated.</p>