Re: Why not SQL Server

MS SQL Server sucks! They only introduced this IRL (insert row level locking) to meet SAP standards. SAP basically said to MS - introduce row level locking or we're not going to allow any of our software against your databases. So MS only has row level locking on INSERTS - only. Everything else is page level - as soon as you get over 20 users on an OLTP system - say goodbye MS. Oh, by the way... the IRL is not the default ... by default inserts are page level also!!! They claim full row-level locking in their next release (7 ?) but we all know how Microsoft works.

The standard number of users on SQL-Server database is 10-20 users. The absolute largest is 200! Oracle can support 1000's... and even the workgroup server's standard user count is above 50. Furthermore, Access, FoxPro, SQL Server - they all use different engines.

I think MS should stay out of the market rather than try to monopolize yet another market with more SUBSTANDARD products.

grant_at_towersoft.com.au (Fuzzy) wrote:

>dbvision_at_inet.uni-c.dk wrote:

>>Can anyone of you tell me why SQL Server is not the right ting for big databases and 300+ users and why Oracle is the best for this purpose.
 

>>Thanks
 

>Tore,
 

>The basic problem is that until the most recent version of SQL Server
>(6.5), it relied on page locking, not row locking. This means greater
>probability of contention, especially when we're talking 300 odd
>users. Oracle has a fairly sophisticated (some would say cumbersome)
>lock regime, but it is based on row locking, and rarely has a problem
>with contention.
 

>With SQL Server 6.5, Micro$oft has introduced 'sort-of' row locking,
>but I haven't used it yet (the CD is still in the wrapper), so I can't
>comment too much on it, other than what I've read. Basically, it
>gives the options to use page locking, row locking, or some of both.
>Sounds dicey to me.
 

>(Note: I'm an avid Micro$oft hater, except when it comes to SQL
>Server, so take these comments with a grain of salt.)
 

>Ciao
>Fuzzy
>:-)

>-----------------------------------------------
>Grant Allen | "Woo Hoo!"
>grant_at_towersoft.com.au | H. Simpson
>-----------------------------------------------
>The contents of this post are my opinions only.
> If swallowed, seek medical advice.
Received on Mon Jun 24 1996 - 00:00:00 CEST