Post reply

Is there to reduce the duration of slow running queries

  • March 22, 2010 at 12:16 am

    #156806

    Hi all,

    I have one procedure it is taking time and i want to improve the speed for that procedure ,explain how to improve the performance in slow running procedures and queries

    Br,

    Karthick

  • March 22, 2010 at 3:54 am

    #1137470

    First of all read this post http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx

    Additionally read the execution plan, what are the hot spot areas. you can post exec plan along with table and index defintion here , so that we people can look into it and give suggestion

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply