Report question

Question: Do Stored Procedures really boost performance in MS SQL / .NET?