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 ...

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.

In-Depth Tour de SQL Finale, Part IV: Replication Our final sprint to the finish line stretches over replication: its limitations, high availability and the many improvements since the last version.

Among the major elements in the new release, says Jonker, are real-time loading into Sybase IQ, advanced technology for dealing with high-volume transaction replication, and improved performance as it ...