Microsoft's Embedded Database - SQL Server Compact - Team Blog

SQL Server Compact is a SKU of SQL Server family of products from Microsoft. This is a thin light-weight, embedded, in-proc database engine which supports synchronization to SQL Server, etc.

Browse by Tags

Tagged Content List
  • Blog Post: After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time

    If you move a SQLCE database from one platform to other, it's first SqlCeConnection.Open() takes more time and also increases the database file size. The Reason : F or an index on string type columns, SQLCE uses LCMapString API to get the normalized sort key. LCMapString API behavior will be different...
  • Blog Post: Sync Services optimizations

    There are some optimizations that can be done for an "Sync Services" sync scenario. These are, (might not be an exhaustive list) Small sync chunks (using smaller SyncGroups which are only absolutely necessary) Index creation on tracking and filtering columns Transfer encryption of data payload...
  • Blog Post: Query performance

    Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly complicated process, but it can be extremely rewarding in some cases. In this post, I am going to list down some ways in which you can tune the query performance for SQL Server Compact, along with pointers...
Page 1 of 1 (3 items)