Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    58

    Question Unanswered: Where can I get materials about Query Optimization in SQL server?

    It is said that, aimed at the same task, different SQL Select Statements maybe have different efficiency. Microsoft Corp. has provided the tool,Query Analyzer, but I have not any idea.

    Thanks.

  2. #2
    Join Date
    Apr 2006
    Posts
    33
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

  3. #3
    Join Date
    Aug 2006
    Posts
    58
    Than you,David Wiseman.

    I have visited the website.It is very nice.

    Good luck!

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    sql server books online (probably installed on your computer) has a whole top level section (under contents) called optimizing database performance.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Aug 2006
    Posts
    58
    thank all,
    I will try my best.

Posting Permissions

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