Tag Archives: SQL Server 2008

Should I use OUTER JOIN instead of NOT EXISTS?

NOT EXISTS in a query can readily be replaced by an OUTER JOIN. Here is how This is because of the fact that in an LEFT OUTER JOIN every row in the left table is represented in the result set, … Continue reading

Posted in Programming, SQL | Tagged , , , , , , , , , , | Leave a comment

Allow SQL Server to use more RAM

On a default 32 bit Windows Server setup, 2 GB of RAM is the most that a SQL Server instance can use. Let’s say a server has 10 GB of RAM that is running nothing but the OS and SQL. … Continue reading

Posted in Programming | Tagged , , , , , , , , | 1 Comment