SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login

Home Forums Article Discussions Article Discussions by Author Discuss content posted by Brian Ellul Tips to optimize your SQL statements RE: Tips to optimize your SQL statements

  • wbrianwhite

    SSC Eights!

    Points: 954

    More actions

    July 29, 2010 at 3:40 pm

    #1200074

    Make sure your where clause is SARG-able or indexes won't help:

    http://weblogs.sqlteam.com/dang/archive/2009/03/07/Low-Hanging-Fruit-of-Sargable-Expressions.aspx

    • About SQLServerCentral
    • Contact Us
    • Terms of Use
    • Privacy Policy
    • Contribute
    • Contributors
    • Authors
    • Newsletters
    Redgate logo