>SQL Server best practices are no different for VFP devs than they are for anyone else. In other words, any document that explains best practices will work.
>
>
>>Hi,
>>
>>Is there any document available for foxpro developers to get some guidance for creating database and tables in MS SQL server ?
>>
>>Like a unique row identifier even in every child row or PK data types etc.
>>
>>I recently see a link for such a document in a thread (mentioned by Naomi Nosonovsky but not sure). Can someone repeat/link that information here ?
>>
>>TIA
I wouldn't say "no different", in the sense that SQL Server (especially newer versions) has so many new features. As one example, you can create staging tables with many different in-memory options, based on usage patterns.
Sure, there are many best/recommended practices that transcend any one database product (every row should have a unique identity, proper data types, etc.)
But given that MS SQL is immensely more scalable than VFP, there are also going to be practices/recommendations specific to the product.