>A DBA asked me (in email) what are the "character set, CPU, and memory" requirements for SQL Server for my VFP 9 application. I need help in replying and sounding professional :).
>1 Usually when I install SQL Server Express on customers' servers (where they don't have a DBA) I leave all defaults. Which means, what "character set" am I using?
>2 I never specify CPU because the VM servers customers built is sufficient for running SQL Server 2008 Express. What should I indicate as a minimum CPU?
>3 SQL Server Express uses only 1GB of RAM on the server. Would it be correct to say that "1GB of RAM is the memory requirement"?
>
>TIA

Hi Dmitry,

1) https://msdn.microsoft.com/en-us/library/ms175194.aspx
To maintain compatibility with earlier versions of SQL Server, or applications that were developed with SQL Server collations in earlier versions of SQL Server, SQL Server offers the SQL_Latin1_General_CP1_CI_AS collation as the default collation for server installations on computers that use the English (United States) Windows system locale.

2) For SQL Express you don't need specify CPU, because it's SQL Express - but you can write dual core (second core for next instance)

3) SQL Express cannot use more than 1GiB Ram - the limit is 1 GiB Ram (for instance).

MartinaJ