RE: [DFW CFUG] SQL Server options

[Jeff Lucido]

Yes, you are correct. MS limits the Express edition to a database no larger than 4GB, can only address one processor and can only use 1GB of RAM. There are several other features disabled as well, but I think MS posts a comparison chart on their site concerning the differences in SQL 2005 editions.   Also, another thing to consider, if the database server is going to be used strictly as a database for a web application then licensing is per processor (so the ~$6400 license really becomes ~$13K for a two processor machine). Finally, if this is a hosted application for a third-party then I am almost positive you have to belong to the MS Service Provider Licensing (SPLA) service where you pay monthly for the use of SQL Server, per processor (which for 2000 used to be $169/mo/processor) instead of purchasing the full license outright (you also get free upgrades for as long as you are in the program).   Good luck, -JSLucido From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of bsd Sent: Monday, July 24, 2006 4:18 PM To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' Subject: RE: [DFW CFUG] SQL Server options I’m curious, though… .wouldn’t the express edition have significant limitations regarding the number of connections or current users or something along those lines?  Cant’ imagine Microsoft (of all companies) giving away something that they also charge $3400 or $6000 for.    From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Jordan Sent: Monday, July 24, 2006 3:52 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] SQL Server options   Oh! Brad. I just remembered that SQL Server has a free version out (MS SQL Server Express Edition). There are a couple of limitations, but speed is not one of them. We just moved one of our big clients to it so they could see the speed improvements and so that they'd feel better about shelling out the cash. http://www.microsoft.com/sql/editions/express/default.mspx Chris bsd wrote: Thanks… I think he would definitely tolerate some latency if it saved him $6K.  I’ll check HostMySite out.   Brad   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Brent Helms Sent: Monday, July 24, 2006 3:41 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] SQL Server options   I've been somewhat pleased with HostMySite's shared Sql Servers.  Its not ideal, but 6000 versus a little slower response times, well there is the answer to your question.  How much dependency does the client's application place on speed versus initial costs?  you can always later move to a dedicated server, and the shared server on HostMySite has been ok for me so far. On 7/24/06, bsd <[EMAIL PROTECTED]> wrote:   I have a client who needs to get a SQL Server database up and running for his business.  He didn't particularly thrill at the idea of shelling out $6000 for a server license.  Does anyone have experience with a hosted SQL Server provider that they would recommend (or NOT recommend)?  Any pros or cons?  Any other options I'm not considering?   Thanks,   Brad _______________________________________________ Reply to DFWCFUG:  List@list.dfwcfug.org Subscribe/Unsubscribe:  http://lists1.safesecureweb.com/mailman/listinfo/list List Archives:     http://www.mail-archive.com/list%40list.dfwcfug.org/   http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors:  www.HostMySite.com   www.teksystems.com/       _______________________________________________ Reply to DFWCFUG:   List@list.dfwcfug.org Subscribe/Unsubscribe:   http://lists1.safesecureweb.com/mailman/listinfo/list List Archives:     http://www.mail-archive.com/list%40list.dfwcfug.org/               http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors:   www.HostMySite.com   www.teksystems.com/

_______________________________________________
Reply to DFWCFUG: 
  List@list.dfwcfug.org
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.HostMySite.com 
  www.teksystems.com/