| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2007-06-04 : 09:21:59
|
| Ok from what I understand, sqlserver 2005 is FREE, and it is not limited by the number of concurrent connections etc etc.So this means you can put sqlserver 2005 express on a dedicated server, and it can pretty much handle all the load you can throw right? (except if your say running myspace hehe)Comments? |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-06-04 : 09:54:34
|
| That is correct. It's free as in beer. It is limited by the amount of RAM it can use and the size of the databases. I run SQLTeam on it and it works just fine.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2007-06-04 : 10:05:02
|
| Well just about 99.99999999999% websites can run on a single server, with 1 GB of RAM and under 4GB database. (that's database, meaning you can even create another database for your application if you go over the 4gb limit).Maybe even slashdot can run on a single server hehe. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-06-04 : 10:05:31
|
quote:
Originally posted by graz
That is correct. It's free as in beer. It is limited by the amount of RAM it can use and the size of the databases. I run SQLTeam on it and it works just fine.===============================================Creating tomorrow's legacy systems today.One crisis at a time.
When did that happen?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-06-04 : 10:20:38
|
| At the same time we moved to a dedicated server for the site. Late April if I remember correctly. I keep meaning to write up something on it but haven't had a chance yet.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-04 : 11:26:18
|
| >> I run SQLTeam on it and it works just fine.No waste of beer money there then.It's one of the few genuinely free databases - unlike mysql for which you need to buy a licence.I'm a bit surprised that MS didn't restrict it more as it could replace quite a few commercial sql server systems.==========================================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. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-04 : 13:30:42
|
| Since it doesn't include the SQL Agent, how do you run scheduled backups?CODO ERGO SUM |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-06-04 : 14:19:23
|
| Just using the Windows scheduler to call osql commands. It's actually something that Orcsweb setup and I haven't really looked it yet.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2007-06-04 : 16:40:46
|
| why would anyone want to backup their db anyhow? hehe |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-04 : 16:57:06
|
quote:
Originally posted by sql777
why would anyone want to backup their db anyhow? hehe
I didn't say I wanted to back them up.I just want a plausible way to explain how it is being done. CODO ERGO SUM |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-04 : 17:00:03
|
quote:
Originally posted by sql777...Maybe even slashdot can run on a single server hehe.
If /. users found out it was running on a Microsoft product, even a free one, there would be a riot.CODO ERGO SUM |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-05 : 08:34:54
|
| Backups are an admission that your system might fail.Bit like testing your code is an admission you might make a mistake (I think of it as testing the compiler).==========================================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. |
|
|
|
|
So SQLServer 2005 Express is FREE?