So you need to build a mobile enterprise app that runs on Windows tablets… Your app must retrieve data from SQL Server and take it offline. It must allow the mobile user to view, manipulate, capture new information, and then
It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.
With the new version 4.0, the little-database-that-could has grown up into a powerful server database ready to take on the web.
Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is uniquely identified by its Primary Key.
All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.
The act of tracking changes made by each SQL Server Compact or Silverlight sync subscriber can cause a lot of locking and blocking on the server.