SQL Server also offers an "array insert" possibility via .NET, which is called bulk copy . I wrote a similiar application as with the Oracle ODP.NET array insert. The point was not to compare Oracle vs. SQL Server, but to verify if the bulk copy is really faster than a normal insert via the...

Stefan Frutiger from Trivadis has extended my performance tests with linked server between SQL Server 2005 and Oracle 10g. First the hardware setup was enhanced: - 2 IBM laptops (T41 and T42) with W2003 and 1GB RAM - crossed cable as dedicated network ...read more

Because of some performance problems with Linked Severs between SQL Server and Oracle, I did some additional tests. I tested Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer ...read more