Added by on 2014-11-25

In this video, Kevin Kline discusses why unwanted recompiles can hurt the performance of your SQL Server. He starts out by explaining why SQL Server keeps compiled code in the cache. Then he moves into the reasons why SQL Server will need to run a recompile on your code. He also discusses the importance of using a call out such as WITH RECOMPILE so that you know that the plan that exists in cache is going to be thrown out and a new one will be created.

Category: Quick Tips   

Leave a Reply

Your email address will not be published. Required fields are marked *