Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Tips and Tricks SQL Compact Mobile CE   (RSS)
Tuesday, July 14, 2009 7:27 PM

Dealing with very large SQL Compact database files

Working with very large SQL Compact files, you may run into two issues: 1. Manipulating a large SQL Compact database in VS 2008 IDE requires a hotfix http://support.microsoft.com/kb/968436 Error message when you use the Visual Studio 2008 IDE to manipulate
Posted by sqlblog | 0 Comments
Wednesday, June 24, 2009 3:12 PM

Performance: Tips for faster download of a large SQL Compact 3.5 database via Replication

SQL Compact 3.x Replication initial subscription is resource-intensive and may take significant time on devices. Read the introduction to the SQL Compact Blog for this problem. Introduction ( from SQL Compact Blog ) “The initial subscription is going
Posted by sqlblog | 0 Comments
Wednesday, April 15, 2009 7:53 PM

SQL Compact Performance: PostSyncCleanup to turn off UpdateStatistics during initial download of SQL Compact Replication

SQL Compact Replication initial subscription may take significant time on devices. The UpdateStatistics operation adds additional overhead to the initial download. Indicators: The Client Agent log may show the start and end times of UpdateStatistics operation.
Posted by sqlblog | 1 Comments
 
Page view tracker