SQL Server Archives - Rob Tiffany

How to Create In-Memory Database Tables in SQL Server 2014

December 31, 2019August 18, 2014 by Rob Tiffany

Getting data off disk drives and into RAM is the biggest game changer for relational databases in decades and #SQLServer 2014 brings it to the masses.

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

August 18, 2016March 9, 2011 by Rob Tiffany

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 more things can happen in a given period of time, then you can derive greater … Read more Reducing SQL Server Sync I/O Contention :: Tip 5

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

August 18, 2016February 27, 2011 by Rob Tiffany

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 technologies figure out “what’s-changed” on the fly when a Subscriber synchronizes. This means all change-tracking … Read more Reducing SQL Server Sync I/O Contention :: Tip 4

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

August 18, 2016January 10, 2011 by Rob Tiffany

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.