Re: Microsoft claim to fame : The TeraServer on The Web

In article <6o0qav$nuf$1_at_uranium.btinternet.com>, "Adrian Shepherd" <Adrian.Shepherd_at_BTINTERNET.COM> wrote:

> I would have replied to the original post but it smacks of somebody somehow
> in Oracle's pocket.

Lead pipe challenged weenie. I'm in nobody's pocket. I have more than just a few years of SQL-Server experience and have done administration, development and support on SQL-Server since the old buggy 4.x days. The last 2 years I have also been working on Oracle Parallel Server on massive parallel processing architecture with very large databases. -MY- opinion is that SQL-Server is ideally suited for the lower-end RDMS market and for small datamarts in the data warehouse arena. But that it does not hold a candle to a database like Oracle (or even Informix) when it comes to the high-end market. And I am not the only one with this opinion in comp.databases.*

So now Microsoft is about to release SQL-Server 7 Enterprise, aimed at the high-end db market. Have they addressed my concerns about SQL-Server's capability of handling VLTs and VLDs with their TeraServer - definately NO. It's not the size of the row that matters, it is the number of rows.

Let's take a data warehouse in the retail market with a billion rows. Not that uncommon. How will SQL-Server handle this? Does it support partioning, and if so what type and how is it implemented? Can it fire off 1000 parallel query processes each processing a chunk of the billion rows? What about indexing? Or bitmap indexing? And do Microsoft expects us to run a DBCC on the database as "preventative maintenance?" (and no, I'm not interested in what the Microsoft marketing dept has to say about SQL-Server - I want to know what my technical peers think)

So instead of trying to insult me by saying that I'm paid by Oracle to voice my opinion Adriaan, why not get your lead pipe and join the fray. :-)

regards,
Billy Verreynne

--
Verreynne Software Labs
Johannesburg
South Africa


-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum