Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 What version of SQL do I need?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-10-29 : 08:32:48
Jeff writes "I am setting up a web server. No problem, but I have been asked to install SQL server with it for the web site to use.

I do not use SQL, have some experience with MySQl but I am guess I need SQL 2000 or Express?

The server will be running Windows 2003 ENT.

I expect the databases to get large. Probably of 4 GB. Guessing.

Any suggestions would be greatly appriciated.

Thank you

Jeff"

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-10-29 : 09:04:09
This isn't my sort of question usually, but I'll give it a shot:

4gb isn't that big. How much will it be used? What can you get funding for?

I would initially say MS SQL 2000 Standard would do it, you could get Enterprise if there will be a real heavy load on it.

Licensing should be by processor...

Anything else guys (& gals)?

Corey
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2004-10-29 : 09:20:57
Get someone who knows what they are doing to advise you.
Creating a 4GB data store for a web site is not sonmething you are likely to get right without knowing about sql server.
That applies to both the installation and data access.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-10-29 : 10:37:05
License for SQL for a Web box is expensive - particularly if you are used to MySQL prices

Kristen
Go to Top of Page

surefooted
Posting Yak Master

188 Posts

Posted - 2004-10-29 : 10:41:04
Which is when you definitely go per proc.

-Jon
Should still be a "Starting Member" .
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-10-29 : 17:28:59
The SQL 2005 Express Data Sheet shows a capacity of about 4 GB, so it sounds like you'd be right there and probably should go with SQL 2000 Standard instead. Too bad, you'd have liked the price of Express...

-----------------------------------------------------
Words of Wisdom from AjarnMark, owner of Infoneering
Go to Top of Page
   

- Advertisement -