Roy Ernest (11/16/2010)

---

There is nothing special about setting it up. 2005 to 2008 is something that is done quite regularly. Just make sure that your distributor is SQL 2008 and...

If the publisher was to fail there would be no way of syncronising between subscribers until the publisher was restored/recovered.

Peer to Peer transactional replication could tollerate a single point of...

Jeff Moden (11/14/2010)

---

Once you get TempDB moved, do your self a couple of favors. First, set the initial size to 12GB (in your case based on the numbers you...

There is no way of restricting resource use on tempdb.

You may be able to use the resource governor to restrict CPU/Memory use but I've never implemented this so...

So you're saying there is a missing row on the subscriber and you want to insert it?

There are a couple of ways. Probably the easiest is to create an...

Can I mention that to be PCIDSS compliant you CANNOT store the CV2 number for any purpose after a tranasaction has been complete.

Also, this is how I would have done...

Hi,

I have compared these prior to applying them in the past however this article describes it in detail. The short version of it is, if the table uses a...

Hi,

This would probably be better on a Windows/Network admin group.

If this new domain going to be a child of the original domain or completely seperate? If it is child...

Thats true but I never said it did. Simply, if performance was a consideration the default trace does provide some insight into what...

The cheapest and probably quickest way to get some monitoring inplace is to setup a combination of serverside perfmon and sql traces.

These can use the lightweight default trace if performance...

Its probably better if you start a new thread as this post is 2 years old.

What I actually meant is, run this on the publisher and the...

We do this on a fairly regular basis and can be done using a "nosync" subscription. You will still need to generate a replication snapshot which shouldnt but may...

Hi,

You may want to look at this forum thread.

I was experiencing a SOS_SCHEDULER_YIELD issue in addition to performance problems. Following a weeklong running call with microsoft we resolved the...

This is data releated and down to the size of the returned data grid. Is there a reason for want ALL the data from this table?

I've seen this a...