Re: newbie queston: why would anyone use Oracle?

From: vc <boston103_at_hotmail.com>
Date: 22 Sep 2005 11:46:51 -0700
Message-ID: <1127414811.493940.155330@g49g2000cwa.googlegroups.com>

David Portas wrote:
> Page size is 8K, which is also the maximum row size (excluding LOB data).
....
> Now in SQL2005 we can create logical partitions across multiple
> filegroups, which is a big win for high availability and scalability.
>

There is a feature in SQL2005 partitioning implementation that affects loading data into a partitioned table. Namely, the bulk load process attempts to pre-sort data before actual insertion. One can quickly run out of space in tempdb if the amount of loaded data is substantial.

> While we're on scalability, some much larger databases both Oracle and MSSQL
> are cited here: http://wintercorp.com/
>
> David Portas
Received on Thu Sep 22 2005 - 13:46:51 CDT