Monitor query performance with the SQL Server 2005 procedure cache

(Tim Chapman) In SQL Server 2005, you only need to recompile the statements inside stored procedures. This is much different than SQL Server 2000, where the entire procedure or batch may be recompiled. The benefit to the statement level recompile in SQL Server 2005 is that typically just a few state

Read More - Register for Free Membership