Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mikael Eriksson Parameter sniffing RE: Parameter sniffing

  • October 17, 2013 at 1:31 pm

    #1659477

    IgorMi (10/17/2013)

    If you use exec sp_recompile 'T'

    you'll get results (compiled values) "Kelle" and "Pelle"

    If you use exec sp_recompile 'GetIt'

    you'll get results (compiled values) "Kelle" and "Urban"

    Which is what I did... 🙂 forgot about statement recompiles.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]