insert X select * from X

(4194304 row(s) affected)

00:00:44

This was on a little twin processor Dell blade thing.

I strongly suspect his XX terabyte 32 processor Sun Oracle server
licence is going to be renegotiated on price in a few month't time.

How did your result compare to the Sun/Oracle system then? A single
INSERT probably isn't a very meaningful benchmark of a system that
presumably has to support many users and processes concurrently.You
might like to refer you boss to: www.tpc.org

--
David Portas
SQL Server MVP
--

I'm just working it out, though it's got a SAN.

Ooops, just pressed send too early.

I'm just working it out, but it's got a SAN so I expect it to be a
hundred times as fast.

This isn't my position though. Ian's laptop conundrum says you only
need what you need.

If we can replace a f*ck off huge Oracle installation with a single
simple cluster, then that's enough to save my boss hundreds of
thousands in fees, since he doesn't really like being told "If you
change the number of users downwards, you have to buy new licences
because of the support contract."

I had to rework both queries to do something more representative. SQL
server was twice as fast for the code I ran, but the hardware wasn't
identical. (Who cares, we've got thirty of these Wintel boxes lying
around from another project.)

SQL 31 S for our free hardware.
Oracle 64 S for our hardware we have. Can't run it on the live box.
Sybase ASE. (SAN) 2 mins 12 on a big machine.
Sybase IQ. (SAN) 12 seconds.