>>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
Thank you, Martina. This is very helpful.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham