The reason why I post this question is my app almost throws timeout exception for the first time running after restoring database. It also happens when I...
Maybe there is a misunderstood. Using sp_recompile will make all my store procedures recompiled each time they are excuted. That is not what I want because it will slow down...