Post reply

Doubt clarification

  • January 6, 2011 at 11:15 pm

    #1270428

    sorry i am a beginner so it takes time for me to understand it.

    another question

    what are all the basic things i need to check up for tuning any stored procedure?

  • January 6, 2011 at 11:54 pm

    #1270440

    deepikamm (1/6/2011)

    sorry i am a beginner so it takes time for me to understand it.

    another question

    what are all the basic things i need to check up for tuning any stored procedure?

    http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx

    I'm pretty sure that if you google or bing 'sql server stored procedure performance", you'll find plenty of hits.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 7, 2011 at 12:11 am

    #1270449

    I have already read this article and also lots related to it.

    I want to know what do you guys(sql server experts) do when you are asked to tune a stored procedure?what are all the basic things u check up? i need some tips..I don want any theory..i want u guys to share ur experience. please suggest some tips for beginners like me.

  • January 7, 2011 at 12:26 am

    #1270454

    deepikamm (1/6/2011)

    sorry i am a beginner so it takes time for me to understand it.

    another question

    what are all the basic things i need to check up for tuning any stored procedure?

    May I kindly remind you to start a new thread for a new topic? The structure of this forum is not by user. It's by topic. On the other side, don't start a new thread if you didn't get a reply within an hour... 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 7, 2011 at 12:28 am

    #1270455

    I hav lot of doubts..so shall i start a new thread for each doubt?

  • January 7, 2011 at 12:38 am

    #1270462

    Yes. But do some research and reading up first, and also it would help people find your questions if the titles were meaningful.

    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

  • January 7, 2011 at 12:38 am

    #1270463

    deepikamm (1/7/2011)

    I hav lot of doubts..so shall i start a new thread for each doubt?

    If these doubts are not related to each other. Yes.

    If you only have one topic, with already a lot of replies, people will assume your problem is already fixed and they will not read the thread. If you have a new thread, it is clear that you have a new problem.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 7, 2011 at 12:44 am

    #1270467

    clear..:-D

Viewing 8 posts - 16 through 22 (of 22 total)

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