• Dear reader,

    What I meant by thae statement is the following:

    Usually developers tend to use TSQL from their application instead of SP's. Then their plan cache fills up faster that usual. Then they use OPTION (recompile) as an answer to reduce plan cache contention. And continue to use adhoc TSQL code from their application. This kills the many benefits of SP's completely.


    Kindest Regards,

    M Suresh Kumar