Post reply

SQL Optimization :

  • May 27, 2013 at 3:58 am

    #293750

    Hi All,

    I need general advise about optimization ,

    I have many stored procedures , It takes more time to execute (more than 5 mins).

    I need to optimize , I can not able to post that procedures.

    So generally advise ,

    what are all need to avoid while creating stored procedure ?

    How to optimize old stored procedure ?

    What are all need to include while creating stored procedure ?

    Thanks,

    Chandrahasan S

  • May 27, 2013 at 4:04 am

    #1618729

    http://www.amazon.com/Server-Query-Performance-Tuning-ebook/dp/B008E6HOIS/ref=nosim/sitw-20

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 28, 2013 at 12:07 pm

    #1619081

    Thanks for the link Gail.

    You need to start slow. Identify the query that is causing you the most pain. Figure out what's wrong with it. Fix that, then move on to the next query. There's no shortcut to make this easier. It's just about hard work.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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