Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    59

    Unanswered: How to Tune Sql query?

    Hi,
    How to tune the sql statements?

    Is there any material which helps in tunning sql statements?

    Regards

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    see Performance and Tuning: Monitoring and Analyzing

    Chapter 3
    Using Statistics to Improve Performance
    Chapter 4
    Using the set statistics Commands
    Chapter 5
    Using set showplan
    Chapter 6
    Statistics Tables and Displaying Statistics with optdiag
    Chapter 7
    Tuning with dbcc traceon

Posting Permissions

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