how can tune the query

• Simha24

  SSCommitted

  Points: 1984

  More actions

  January 16, 2012 at 2:07 am

  #249084

  HI

  I have couple of questions. please provide if you have any KT articles.

  1. How can tune query.

  2. What are approaches for tuning a query .

  3. Which are things i need to focus before tuning a query.

  4 How can i advice to my developers.

  How can reach them to provide better solutions in performance optimization.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 16, 2012 at 2:16 am

  #1433936

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_1?ie=UTF8&qid=1326705367&sr=8-1

  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

• Simha24

  SSCommitted

  Points: 1984

  More actions

  January 16, 2012 at 2:24 am

  #1433937

  Thanks for providing...

  i will go through it....