Results 1 to 3 of 3

Thread: SP Optimization

  1. Feb 25th, 2009, 01:19 AM #1
    Guvera
    Guvera is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2007
    Posts
    241

    Thumbs up SP Optimization

    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
    Failing to plan is Planning to fail
    Reply With Quote Reply With Quote
  2. Feb 25th, 2009, 04:10 AM #2
    kevchadders
    kevchadders is offline
    Hyperactive Member
    Join Date
    Jan 2008
    Location
    Merseyside
    Posts
    456

    Re: SP Optimization

    (Based on SQL Server)
    Using and understanding the execution plan is a good start.
    Also SQL Profiler is a useful tools as well.

    Seme SQL Server Stored Procedures Optimization Tips
    http://www.databasejournal.com/featu...ation-Tips.htm

    Execution Plan Basics
    http://www.simple-talk.com/sql/perfo...n-plan-basics/

    Of course if its not SQL Server you are using it will be worth letting us know what database backend your question relates to.
    If I've helped, please RATE my post.

    Some Informative Links: [Useful T-SQL Factsheet ] [T-SQL DateTime DataType][10 Most Asked SQL Questions and Answers][Connection Strings Refs]
    Reply With Quote Reply With Quote
  3. Feb 25th, 2009, 05:32 AM #3
    NeedSomeAnswers
    NeedSomeAnswers is offline
    Superbly Moderated NeedSomeAnswers's Avatar
    Join Date
    Jun 2002
    Location
    Manchester uk
    Posts
    2,657

    Re: SP Optimization

    Do you have any specific problem Stored Procedures or is this just a general question ?
    Please Mark your Thread "Resolved", if the query is solved & Rate those who have helped you


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width