Query Optimization

• GBeezy

  SSCarpal Tunnel

  Points: 4723

  More actions

  October 12, 2012 at 10:30 am

  #393380

  I have been researching this my self, but I am curious as to the approach others take to optimize queries. Please feel free to throw out Buzz words that I can further research of ways that you feel are best to optimize a query, any tools that you use both free and/or purchased, and any other information that you feel may be relevant.

  Thanks in Advance to everyone that responds...

• Sergei Zarembo

  Hall of Fame

  Points: 3887

  More actions

  October 12, 2012 at 11:03 am

  #1548770

  this book

  http://www.amazon.com/Server-Query-Performance-Tuning-Distilled/dp/1590594215

  has a lot of buzz words on the topic.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 12, 2012 at 12:18 pm

  #1548799

  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/

  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

• GBeezy

  SSCarpal Tunnel

  Points: 4723

  More actions

  October 12, 2012 at 12:46 pm

  #1548807

  Thank You everyone for the replies...