more sql performance tips

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.
Your Ad Here

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

  . .