Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Engine   (RSS)
Wednesday, December 12, 2007 10:18 AM

"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 ->
Posted by SQLCEBLOG | 1 Comments
Filed under: ,
Friday, October 26, 2007 8:42 AM

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
Posted by SQLCEBLOG | 3 Comments
Filed under:
Wednesday, June 13, 2007 8:47 PM

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
Posted by SQLCEBLOG | 3 Comments
Filed under:
Wednesday, June 13, 2007 8:28 PM

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
Posted by SQLCEBLOG | 1 Comments
Filed under:
 
Page view tracker