Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQL Serveror ORACLE?
We too are fed up with MS SQL crashing and nuking our database almost every week. We have a 10Gb database, one table has >85million rows. If you hammer the server then it simply starts reading and writing the wrong pages on the disk and you end up with a corrupt database. The solution is to spend three days with the users staring at the ceiling while you transfer row by row into a new database and recreate the indecies. MS admit they have problems with large table support. Oracle 8 eval arrives Monday am, porting starts immediately.
Oh and the query optimiser is a joke too. We have some big queries, and on one day a query will fly, the next day it crawls like a dog, even if nothing has changed. The solution is to tear the queries up into temporary tables, work out and enforce a good query plan.
I hate it I hate it I hate it (and now it's personal!)
John
Mike Adams <103701.1437_at_compuserve.com> wrote in message
<35045496.4DBCDD0A_at_compuserve.com>...
>What are you trying to do that causes it to crash?
>
>Basta wrote:
>
>> My SQL Sever 6.5 SP3 have CRASHED 3-RD TIME while working with Access
>> 97
>> database!
>> I am going to change SQL Server to ORACLE.
>> Have anybody Something to say?
>>
>> --
>> Russian Automotive Publishing House "Za Rulom"
>> Computer Division
>> Ruslan Sulakov
>> mailto:ruslan_at_zr.ru
>
>
>
Received on Sat Mar 14 1998 - 00:00:00 CST