Community

How to Optimize the Use of the ‘OR’ Clause When Used with Parameters

(Preethiviraj Kulasingham) Have you ever tried to use parameter validation within a SQL Server stored procedure using an OR clause? At times, it can cause performance problems. I found this recently when I was asked to fine tune a stored procedure. The procedure had two parameters, and either of the

Read More - Register for Free Membership