Chosing the right hardware configuration for SQL server

Hi,

I need to provide SQL server for 100 or 50 VB clients. Please suggest
the configuration for the above.

thanksRead the first chapter:
http://www.microsoft.com/technet/pr...mindefault.mspx|||"ramankalia" <ramankalia@.indiatimes.com> wrote in message
news:ca9b3ddf.0502071039.2e9d92f4@.posting.google.c om...
> Hi,
> I need to provide SQL server for 100 or 50 VB clients. Please suggest
> the configuration for the above.
> thanks

It's impossible to give any useful answer without much more information, and
even then it might not be possible - you know your requirements and
environment best. In addition to the MS documentation, some hardware vendors
provide sizing tools for their servers, so that could be worth checking out.

Simon

Chosing the best Data Access component for SQL Server Express

Hi all,

I have to chose the best Data Access Component with SQL Server Express edition.

The application that I am going to develope is a simple one but the speed should be as much as possible.

Any help would be highly appreciated.

Thanks & regards

Arun Gupta

The 'best' speed would most likely be attained using the SQL native client and a datareader object.