SQL Server Performance

Search Results

Search Again
  1. Lijo Cheeran Joseph

    Use of Table variable in SQL Server

    Post by: Lijo Cheeran Joseph, Feb 18, 2010 in forum: SQL Server 2005 General Developer Questions
    I am trying to learn optimization in SQL. Following queries explains my thoughts. Both of them took 19 seconds. Is there any scenario in which the...
  2. Lijo Cheeran Joseph

    Use of Table variable in SQL Server

    Thread by: Lijo Cheeran Joseph, Feb 16, 2010, 4 replies, in forum: SQL Server 2005 General Developer Questions
    Hi Team, I am using SQL Server 2005. I have heard that we can use a table variable to use instead of LEFT OUTER JOIN. What I understand is that, we...
  3. Lijo Cheeran Joseph

    ANY and EVERY for HAVING

    Post by: Lijo Cheeran Joseph, Feb 9, 2010 in forum: SQL Server 2005 General Developer Questions
    Thanks for your support. I was looking for the following - HAVING (SUM(CASE WHEN TD.CompletedDt BETWEEN @FromTrainingCompletedDate AND...
  4. Lijo Cheeran Joseph

    ANY and EVERY for HAVING

    Post by: Lijo Cheeran Joseph, Feb 8, 2010 in forum: SQL Server 2005 General Developer Questions
    Hi Thanks for the immediate reply Training(TrainingID INT, TrainingCloseDate DATETIME) TrainingDetail(TrainingDetailID INT,TrainingID INT,...
  5. Lijo Cheeran Joseph

    ANY and EVERY for HAVING

    Thread by: Lijo Cheeran Joseph, Feb 8, 2010, 5 replies, in forum: SQL Server 2005 General Developer Questions
    Hi, Does SQL Server 2005 support ANY or EVERY with HAVING? Suppose I have two tables Training(TrainingID, TrainingCloseDate) and...
Showing results 1 to 5 of 5
Search Again