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.