SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 What version of SQL do I need?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 10/29/2004 :  08:32:48  Show Profile  Visit AskSQLTeam's Homepage
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
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 10/29/2004 :  09:04:09  Show Profile  Visit Seventhnight's Homepage
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

United Kingdom
12543 Posts

Posted - 10/29/2004 :  09:20:57  Show Profile  Visit nr's Homepage
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

United Kingdom
22415 Posts

Posted - 10/29/2004 :  10:37:05  Show Profile
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

USA
188 Posts

Posted - 10/29/2004 :  10:41:04  Show Profile
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

USA
3246 Posts

Posted - 10/29/2004 :  17:28:59  Show Profile  Visit AjarnMark's Homepage
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000