Rob Tiffany

Tag Archive: Merge Replication

Super Scale

Building Microsoft MEAP: Scaling Out SQL Server 2012

In this third article on building Microsoft MEAP, I’ll show you how to Shard your SQL Server 2012 database using Replication to create a Shared Nothing data architecture to support Internet-scale mobile solutions. In the previous article, I discussed Gartner’s Enterprise…
Read more

SQL Server Compact

SQL Server Compact 3.5 Service Pack 2 Cumulative Update Package 7 RTW

Hey folks, just wanted to let you know that cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 has been released to the web. You can download the new bits over at http://support.microsoft.com/kb/2665342. This is a hotfix for an…
Read more

Performance and Memory Management Improvements with Windows Embedded Handheld

It should be no surprise that over 80% of enterprise handhelds shipped are running Windows Mobile or Windows Embedded Handheld.

Trident Submarine

Reducing SQL Server Sync I/O Contention :: Tip 5

When it comes to delivering server solutions with Windows Server and SQL Server, speed is your friend (as we used to say in the submarine service). More speed means more things can happen in a given period of time. If…
Read more

Add Filter

Reducing SQL Server Sync I/O Contention :: Tip 4

One of the features that makes SQL Server Merge Replication superior to other sync technologies is something called Precomputed Partitions. SQL Server creates and maintains distinct data partitions/subsets for each unique user or other type of filter value.  Other sync…
Read more

SQL Server

SQL Server Compact 4.0 Lands on the Web

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.

Primary Key

Reducing SQL Server Sync I/O Contention :: Tip 3

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.

Database Storage

Reducing SQL Server I/O Contention during Sync :: Tip 2

All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.

SAN Storage

Reducing SQL Server I/O Contention during Sync :: Tip 1

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.