SQL Server Performance

Search Results

Search Again
  1. Shobin Mathew

    if else vs OR

    Post by: Shobin Mathew, May 20, 2009 in forum: SQL Server 2008 T-SQL Performance Tuning
    The query is working any way correctly. It is only a aprt of a big query. @var will either contain null or will contain a sequential guid. I just...
  2. Shobin Mathew

    if else vs OR

    Thread by: Shobin Mathew, May 20, 2009, 4 replies, in forum: SQL Server 2008 T-SQL Performance Tuning
    I have a query,SELECT TOP (@BatchCount)column1,column2, column3 FROM [table] WITH (NOLOCK) WHERE[column1] > @var OR@var is Null ORDER BY column1;...
Showing results 1 to 2 of 2
Search Again