In general stored procedures are a batch of SQL statements that can be executed in a couple of ways. So the stored procedure is actually a set of SQL queries. I believe that in performance aspect there will be no significant difference but the stored procedures gives lots of different benefits. I would like to encourage you to review the following help article
that explains some good aspects of using the stored procedures.
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed