We are, however, mirroring the database within site 1. We are not mirroring at site 2. I'm thinking merge replication might be better than transactional with queued updates.

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...