Before this week, my knowledge of SQL was essentially limited to "SELECT blah FROM blah JOIN blah ON blah WHERE blah". Now I'm being asked to do a little more, and while I think I'm getting up to ...

We have two MS SQL Server 2000 machines engaged in merge replication. One is in Houston, the other in Norway. The links are relatively high-bandwidth (6 Meg), but latency hovers in the 150-200ms range ...