Storing queries on the SQL server in the form of stored procedures allows for much easier maintenance. As long as the data returned to the application is in the same result format as it expects, the stored procedure can be updated at the server level, and all applications referencing that procedure will automatically receive the query modifications. No code update is necessary unless columns are added or types changed. Also, SQL Server stored procedures are compiled by default, so the query execution plan does not have to rebuild if the parameters are the same. This can add a lot to performance.