Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Which one of these three (2) WHERE clauses is BEST for PERFORMANCE? RE: Which one of these three (2) WHERE clauses is BEST for PERFORMANCE?

  • January 30, 2014 at 1:03 pm

    #1684825

    I agree with Chris, you should try them.

    However, you might note that No.1 is using a function so it's not SARGable and No.2 is using LIKE with no wildcards, so LIKE operator is not needed.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2