Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Optimizing Stored Procedures To Avoid Recompiles

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-04-05 : 12:39:20
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. Recently started looking at this issue where I worked and stored procedures gathered from other clients and I noticed that there is an issue with SQL developers not taking recompiles into account when they create new code. This is a great article! I've just used the approach to fix a proc that was driving me crazy!

Article Link.


- Advertisement -