Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Engine   (RSS)
Wednesday, April 01, 2009 1:16 PM

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
Posted by SQLCEBLOG | 0 Comments
Wednesday, June 25, 2008 4:20 PM

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
Posted by SQLCEBLOG | 3 Comments
Filed under: ,
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