Monthly Archives: March 2010

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

SQL function to remove extra multiple spaces from string

Here is a very efficient solution for removing multiple spaces from a string. I mean replacing multiple spaces between words in a string with a single space, without using a loop. The technique is very simple, I will just run … Continue reading

Posted in Programming, SQL | Tagged , , , , , , , , , , , | 11 Comments

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