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: Insight into SQL Server Compact database corruptions

    Database corruptions are often the most painful bugs to repro and debug. A good percentage of the SQL Server Compact bugs reported are in this category. However it so turns out that in majority of the cases Compact is not the culprit. Surprised!! Let us see why. How SQL Server Compact detects a file...
  • Blog Post: "Houston, we got some problem..." and "Houston, we got a problem..." - notice a difference?

    So you have run into a problem - how to efficiently report this: System configuration: On a Desktop/Server, Run Winver from Start -> Run. On a Pocket PC, Start -> Settings -> About On a Smart Phone, a bit more steps - start -> Settings -> More ->About Give us all the...
  • Blog Post: SqlCeEngine/ISSCEEngine: Shrink Vs Compact

    The difference between these two is much similar to Internal and External Memory Fragmentation. From SqlCeEngine.Shrink documentation, Reclaims wasted space in the database by moving empty and unallocated pages to the end of the file, and then truncating the file. You can configure a database to...
  • Blog Post: Connection String - Database Creation-time Only Options

    In this article, we will discuss the Connection String Parameters that are meant for use only for database creation and not for connection open to an existing database. Locale Identifier – LCID tells the engine in which locale/collation the database should be created. Encrypt – As the name suggest...
  • Blog Post: The Story of Max Database Size (Connection String Parameter)

    Maximum Database Size is NOT a persistent configuration (It is NOT stored in database file). SQL CE creates shared memory to support multi-connection scenarios. SQL CE maintains an entry for each page of the database file, in this shared memory. Because we don't always grow to 4 GB, it is not wise to...
Page 1 of 1 (6 items)