Home Forums SQL Server 2008 T-SQL (SS2K8) Sp runs from 7 sec to 10 min (UnitPricingTrans) RE: Sp runs from 7 sec to 10 min (UnitPricingTrans)

  • November 4, 2013 at 9:10 am

    #1663865

    SSChampion,

    How do I get execution plan in XML?

    I would like to see what Gail is talking about in her article about parameter sniffing.

    Especially this part - ColumnReference Column="@StringVar" ParameterCompiledValue="'zzz'"