Thats something I was afraid off. I had a feeling that transactional replication is going to be very very chatty. The bandwidth should be pretty good if the plan works...

Yes, we will be using VPN tunnelling. Also we never enable named Pipes. We always use TCP/IP.

How good is the transactional replication across the WAN? Anyone have any idea?...

Yea, I am sorry about it as well..:D

But We DBAs cannot do much about it. Its upto the Programming / Development team to make sure that they move to the...

It does not look too difficult. Maybe I am missing something. Check this out.

Create table #Person (person int, Club varchar(5), ClubFromDate datetime, ClubToDate datetime)

GO

Create table #Address (person int, Address varchar(25),...

Ah No..It is on our replicated box. We just run queries of it... No Transactions. And this server is an experimental one. We want to see how the CPU and...

When ever I have high I/O operation on queries, I get multiple threads for single SPID (Ofcourse it shows CXPacket as the wait type). One thing I also noticed is...

Paul, I tried the set up three times and the three times it worked just fine.

SP3 and SP3a was soo bad that they had to keep on sending Hot fixes and patches for them. SP3 was the worst SP MS has ever released for SQL...

Animal Magic (4/21/2008)

---

Yes you can run then both side by side on the same machine. One thing i would say is make sure that the sql 2000 instance is...

The Basic reason why I prefer Case over OR is it is much more easier to read. Especially when there are more than one OR condition. It really makes the...

I would suggest you to use a Case statement over an OR clause.

SELECT blah

FROM blah

WHERE IsValid = 1

...

Did you give quotes around Y?

Yes, that article does show some light on the issue. I will set it up as MS says and see if I get the error again tomorrow early morning and...

Thats almost impossible. It has got 32 GIG as RAM and it has 16 CPUs. It is one of the systems that we call it as a "Server Using Steroids"

And...

I think it is time to just stop responding to this thread. I have a feeling there are lots of other people who really needs help from who ever is...