Tag Archives: SQL Server 2005

Importing multiple text files using SSIS

We can import multiple flat files in one go using the MULTIFLATFILE connection manager. This can be used in scenarios where you have multiple files with the same format lying in a directory and you want to import records from … Continue reading

Posted in Programming, SSIS | Tagged , , , , , , , | 17 Comments

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