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.
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 youJeff" |
|
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 |
 |
|
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. |
 |
|
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 |
 |
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-10-29 : 10:41:04
|
Which is when you definitely go per proc. -JonShould still be a "Starting Member" . |
 |
|
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 |
 |
|
|
|
|