• Below are some of the options for parameter sniffing:

    1. Local variables

    2. WITH RECOMPILE

    3. Rebuild index - it creates new plan

    4. Trace Flag 4136 with QUERYTRACEON HINT

    more options can be found at http://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options