Pages

Friday, August 26, 2011

Why stored procedures?

When you compile a stored procedure, SQL Server will create an execution plan and cache it in the server memory. So, next time you don't have to recompile it, thus reducing overhead on server.

No comments:

Post a Comment