Stored Procedures and Caching

(Brian Kelley) One of the biggest performance gains built into SQL Server is the stored procedure. SQL Server has the ability to cache the execution plan for re-use at a later time. While SQL Server 2000 has improved tremendously in caching execution plans for ad-hoc SQL queries, it still hand

Read More - Register for Free Membership