Re: Avoiding any locks in SQL Servers - read and understand....its magic.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f4211e7$0$15038$ed9e5944_at_reading.news.pipex.net...
> > 2. Benchmarks i have never tried (see logicsql, which has shown 30-50%
> > advantage over oracle in special tests. PCMAG has shown, that MS SQL
> > Server 2000 is crap, i give a shit, but i know exactly, when SQL Server
> > is poor performing)
>
> Well then PCMAG, if indeed it did say that, is wrong. SQLServer is not a
bad
> product. It performs very well in its target market, and surprisingly well
> in high volume environments. I'd rather take Oracle but its a case of 2
good
> products in that comparison.

It looks like I need to apologize to PCMAG - from their comparitive review of Database products (postgreSQL didn't get a look in)

"Microsoft SQL Server 2000 SP2 is the hands-down ease-of-use leader in the field, so if you don't have an outsized IT budget, it's a good choice. SQL Server 2000 is also suitable for dyed-in-the-wool Microsoft shops. Don't expect it to be a top performer with a Java app server, but if you work with ASP and VisualStudio, you'll get excellent throughput rates."

They recommend Oracle despite its expense :(

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK