Post reply

SP Optimization

  • February 24, 2009 at 11:19 pm

    #134941

    Hi friends,

    Is any tutorial or useful link for stored procedure optimization with example.

    I searched in google.But it is not enough. Please if you know send me,

    Hope your's reply.

    Thanks & Regards

  • February 24, 2009 at 11:39 pm

    #949802

    Hi

    The following link is giving some useful information

    http://www.sqlservercentral.com/articles/Performance+Tuning/ospr/666/

    Latha

  • February 25, 2009 at 5:41 am

    #949896

    You just won't get enough information from an article for stored procedure optimization. What you need is a book. I'd suggest Itzik Ben-Gan's SQL Server 2008 T-SQL Fundamentals or Inside SQL Server 2005: T-SQL Querying. Those are excellent starting points. You might also check out Joseph Sack's SQL Server 2008 T-SQL Recipes.

    Articles, like the one linked above, are going to focus on a tiny topic of tuning, like recompiles. That's only a small piece of the pie.

    "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

  • February 25, 2009 at 9:07 am

    #950069

    Also Inside SQL Server 2005: Query Tuning and Optimisation which, as it's name implies, is an entire book on query tuning and optimisation.

    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

  • February 26, 2009 at 4:01 am

    #950496

    I've always found http://www.sql-server-performance.com/ to be pretty useful.

Viewing 5 posts - 1 through 4 (of 4 total)

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