more sql performance tips
Posted by nethan on April 24, 2010 · Leave a Comment
As most of you know the general rule in performance tuning is .....
"measure, measure, measure" and "measure again"
But it doesn't hurt to give out some warning signs from time to time. And here goes two:
1) be careful in doing anything fancy on JOIN predicates (that is the condition in the "ON" section)
...
Source: .NET Developer Notes
Disclaimer: PinoyBlogoSphere.com(PBS) claims no credit for any content(posts, articles, texts, images, videos) featured on this site unless otherwise noted. All contents are copyright to their owners/sources. PBS is in no way responsible for or has control of the content of any external web site links. Information on this site may contain errors or inaccuracies; we do not make warranty as to the correctness or reliability of the site’s content. If you own rights to any of the content, and do not wish them to appear on this site, please contact us via e-mail and they will be removed.
Other Posts
- August 8, 2009 -- 24 hours of high quality sql server training for free
- March 3, 2009 -- TSQL to get SQL Server properties
- October 17, 2010 -- The Sumilao Farmers – a Filipino Success Story
- July 25, 2010 -- How to Make Your Social Network WORK for You
- July 25, 2010 -- Day 1 – No Coke Campaign
- July 25, 2010 -- Affirmation: One Step At A Time
- July 25, 2010 -- I’ve Got Mail
- July 25, 2010 -- Umulan Tapos Bumaha Na Naman
- July 25, 2010 -- Tacky, plastic lampposts defile heritage, glorify thievery
- July 25, 2010 -- Introducing Filipinos to the Philippines
- July 25, 2010 -- Cebu Institute of Technology – University a.k.a. CIT University
- July 25, 2010 -- Further studies in Norway
- July 25, 2010 -- Master of Arts in Visual Arts and Curatorial Studies
- July 25, 2010 -- Master Program in Digital Exhibit and Set Design
- July 25, 2010 -- Master Program in Interior Design “New Domestic Landscapes”
- July 25, 2010 -- Master in Photography and Visual Design
- July 25, 2010 -- Master of Arts in Textile and New Material Design
- July 25, 2010 -- RICO’S NEW BLOG SPOT
- July 25, 2010 -- VICTORY HUMAN RESOURCES MANAGEMENT CORP.
- July 25, 2010 -- VICTORIAN PLACEMENT AGENCY
