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:25 am

    #1663873

    RVO (11/4/2013)

    Ten Centuries,

    "...Have you looked at indices and stats before changing the code?..."

    No I have not done this.

    I am not a big guru when it comes to TSQL performance tuning.

    Can you tell how to do that and how to analyze that data?

    Execute your query with actual exec plan option enabled, save the plan and post it here.