Which Edition for Websites?

Last Post 14 Oct 2007 09:47 PM by SwePeso. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
elkano
New Member
New Member

--
14 Oct 2007 07:15 PM
Hi there,

I'm looking at setting up several websites and need a database to store the information used to generate the website as well as customer transactions.
I have a copy of Windows 2005 standard edition but I'm not sure if it is licensed and/or legal to use this when the user base will be unknown. I note that the workgroup edition can be used for this purpose, do I need to purchase that or does the standard edition include the necessary licensing.

Thanks,

Kano
SwePeso
New Member
New Member

--
14 Oct 2007 09:47 PM
Maybe SQL Express (with Advanced Features) is the edition for you?
4 GB database, only 1 processor.
SQLUSA
New Member
New Member

--
18 Oct 2007 08:47 PM
For high traffic sites you need SQL Server 2005 Enterprise Edition. That is designed for 24/7 operations. 2 major features Microsoft charges premium: online indexing and table partitiioning.

Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com/order2005grandslam
SwePeso
New Member
New Member

--
24 Oct 2007 11:43 PM
quote:

Originally posted by: SQLUSA
For high traffic sites you need SQL Server 2005 Enterprise Edition. That is designed for 24/7 operations. 2 major features Microsoft charges premium: online indexing and table partitiioning.

And you have to buy a license for $25,000 per used processor. Maybe not an option for a small or starting company.

It depends on the volume of the traffic. And the nature of the traffic.
If all the visitors do is reading articles, SQL Server Express is good enough. Even for a small bulletin board.




SQLUSA
New Member
New Member

--
25 Oct 2007 10:46 PM
Per CPU ballpark like this:

Standard Edition $4K

Enterprise Edition $18K

Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com
SwePeso
New Member
New Member

--
26 Oct 2007 01:10 AM
What an discount then! ;-)

According to http://www.microsoft.com/sql/howtob...fault.mspx retail price is $24,999

SQLUSA
New Member
New Member

--
26 Oct 2007 03:23 AM
Yes, prices vary. A bit confusing discounted offerings....

Here is the $18K link: http://www.softwaremedia.com/product/1744.html
You are not authorized to post a reply.

Acceptable Use Policy