We are currently decide on Oracle vs. SQL and some of the non-believers thinks SQL can't scale to support 500+ users and 100GB+ database sizes. I would like to provide them with references if possible or perhaps some company names that do so.. Any help persuading them would be appreciated.

-- Anonymous, May 04, 2001

Answers

Dan,

I have not personally worked with a single SQL Server database of that size, but you may find this May 1998 interchange about a 200 GB SQL Server 6.5 database that Neil Pike was successfully administering very illuminating. Look particularly at message 6 and 7 in the thread. In those messages Richard Gaston asks about the details of opeation, and Neil Pike answers.

Given the software advances with SQL Server 2000 and the hardware advances in the last 3 years, you should feel confident in your ability to operate a 100 GB database using SQL Server.

The URL to view this thread is (typed all on one line with no spaces):

http://groups.google.com/groups? hl=en&lr=&safe=off&ic=1&th=d9163a77804da8d2,8&seekm=6ki6qv%246492% 40news.fishnet.com#p

If you have trouble with this URL, go to http://groups.google.com/advanced_group_search and search for messages in newsgroup microsoft.public.sqlserver.server, with a subject of "large databases" (without the quotes), posted between 1 May 1998, and 31 May 1998. Then click View Thread link on the returned thread list (should be just the 1 thread).

Hope this helps,

Eric

P.S. You should be aware that Neil Pike is the most proficient SQL Server practioner in the world.

-- Anonymous, May 04, 2001