Which one to buy?

[Manish]

Hello

Please help me as i am quite new to this.

I intend to buy SQL 2000 but dont know which one to get.
developer/standard/enterprise.

I want to develop databases for multiple clients for their websites
but i dont wish to host them in-house as I will put them in
web-hosting servers which support SQL2k. But at the same time I will
test the database in my PC which is powerful enough i guess. It is a
3.06 Ghrz with 1GB Ram.

Please tell me which SQL2k should i go for?

Thanks in anticipation.

Manish

[Alexey Aksyonenko]

Re: Which one to buy?

Enterprise requires Win2K Server OS, so if you are not running a
server locally - that's out of the question. The only difference
between the diff. releases of SQL Server is the number of admin tools
bundled in, really. Standard should be more than sufficient for your
needs based on the description you gave.
Alexey

manish@bullnose .co.uk (Manish) wrote in message news:<1d7cbdac. 0309260134.44dd b599@posting.go ogle.com>...[color=blue]
> Hello
>
> Please help me as i am quite new to this.
>
> I intend to buy SQL 2000 but dont know which one to get.
> developer/standard/enterprise.
>
> I want to develop databases for multiple clients for their websites
> but i dont wish to host them in-house as I will put them in
> web-hosting servers which support SQL2k. But at the same time I will
> test the database in my PC which is powerful enough i guess. It is a
> 3.06 Ghrz with 1GB Ram.
>
> Please tell me which SQL2k should i go for?
>
> Thanks in anticipation.
>
> Manish[/color]

[Jason]

Re: Which one to buy?

manish@bullnose .co.uk (Manish) wrote in message news:<1d7cbdac. 0309260134.44dd b599@posting.go ogle.com>...[color=blue]
> Hello
>
> Please help me as i am quite new to this.
>
> I intend to buy SQL 2000 but dont know which one to get.
> developer/standard/enterprise.
>
> I want to develop databases for multiple clients for their websites
> but i dont wish to host them in-house as I will put them in
> web-hosting servers which support SQL2k. But at the same time I will
> test the database in my PC which is powerful enough i guess. It is a
> 3.06 Ghrz with 1GB Ram.
>
> Please tell me which SQL2k should i go for?
>
> Thanks in anticipation.
>
> Manish[/color]

Developer edition is out since the EULA states you are restricted from
running it in a production environment. (FYI - Developer edition has
the same features as enterprise.)

Between Enterprise and Standard editions -- Really depends on how much
data you will be storing in the database. Chances are you will NOT
need enterprise. That is for really HUGE databases.

The question becomes which version of standard edition. I could be
wrong but if you are putting it on a webserver then the per-processor
license may be the most cost efficient way to go (instead of CAL's).

[Vincento Harris]

Re: Which one to buy?

manish@bullnose .co.uk (Manish) wrote in message news:<1d7cbdac. 0309260134.44dd b599@posting.go ogle.com>...[color=blue]
> Hello
>
> Please help me as i am quite new to this.
>
> I intend to buy SQL 2000 but dont know which one to get.
> developer/standard/enterprise.
>
> I want to develop databases for multiple clients for their websites
> but i dont wish to host them in-house as I will put them in
> web-hosting servers which support SQL2k. But at the same time I will
> test the database in my PC which is powerful enough i guess. It is a
> 3.06 Ghrz with 1GB Ram.
>
> Please tell me which SQL2k should i go for?
>
> Thanks in anticipation.
>
> Manish[/color]

Depends on what you need but from your descriptions it looks like a
database which has a potential of growth.Also if you intend to have
more than four CPUS at some time then standard edition is out of the
question.
I am not sure about developer but do beleive that you will like to
test your database on the same or similar envioronment on which you
develope

Vince

Vince

[Leythos]

Re: Which one to buy?

> manish@bullnose .co.uk (Manish) wrote in message news:<1d7cbdac. 0309260134.44dd b599@posting.go ogle.com>...[color=blue][color=green]
> > Hello
> >
> > Please help me as i am quite new to this.
> >
> > I intend to buy SQL 2000 but dont know which one to get.
> > developer/standard/enterprise.
> >
> > I want to develop databases for multiple clients for their websites
> > but i dont wish to host them in-house as I will put them in
> > web-hosting servers which support SQL2k. But at the same time I will[/color][/color]

Any MS SQL Server supporting a Web Application requires a CPU license,
you can not use a CAL for applications that are WEB based on hit the DB.

A typical CPU License for Standard costs about $4,950.00 from CDW.

A typical CPU License for Enterprise is about $19,000.00 from CDW.

* Enterprise Edition scales best. Get this if you:
- Need more than four CPUs in the database server. For more
information, see "Maximum Capacity Specification" in SQL Server Books
Online.
- Need more than 2 GB of physical memory (RAM) in the database server.
- Will be dividing database workload across independent servers (that
is, "scaling out").
- Are using System Area Networking (SAN) connection technologies
between servers (for example, Compaq ServerNet II or Giganet cLAN).

* Standard Edition can be used on symmetric multiprocessing systems with
up to 4 CPUs and 2 GB of RAM.
[color=blue][color=green]
> > test the database in my PC which is powerful enough i guess. It is a
> > 3.06 Ghrz with 1GB Ram.[/color][/color]

For development, you can use the MSDE and you should be fine.
[color=blue][color=green]
> > Please tell me which SQL2k should i go for?[/color][/color]

We can't you didn't provide enough information about the data needs of
your clients web sites.

Mark


--
--
spamfree999@rro hio.com
(Remove 999 to reply to me)

[John Bell]

Re: Which one to buy?

Hi
[color=blue]
>
> I want to develop databases for multiple clients for their websites
> but i dont wish to host them in-house[/color]

You need to read the EULA, but developer edition should cover this. If you
are using MS tools, then a subscription to MSDN may be a worth while
investment.

John