Running a snapshot is not reinitializing. The only time this will generate any sort of snapshot is if you add 1 or more new articles then a snapshot containing...

muthyala_51 (9/17/2012)

---

Hi,

I have setup replication with sync type-replication support only and it's working fine. If I need to reinitialize the subscriptions of any publication, do I need to completely drop...

JamesMorrison (9/17/2012)

---

We are testing the ONLINE partitioning process this week. But if we do it that way, it is definitely a performance hit. So we are trying to figure out...

JamesMorrison (9/17/2012)

---

I understand what you are saying with the update trigger directly to the new partition table.

The problem I see with that is if an update to the original...

I should have asked already. What are your reasons for partitioning this table?

Why?

Use the trigger on the source table to insert/update/delete in the "shadow" table.

Any additional tables and logic is adding work and complicating a simple setup

I've done this several times before. You need capacity to store two copies of the table.

-create a partitioned table of the same structure called table_ptn.

-Add a trigger to maintain...

You can but I would only advise this in exceptional circumstances like you are not in a position to updates stats on a very, very large table or in a...

Danzz (9/15/2012)

---

The log scan number (690:13675:299) passed to log scan in database 'DB_Name' is not valid. This error may indicate data corruption or that the log file (.ldf) does not...

Some idea...

Mirroring has an processing overhead on the principle server which can, and does, have a performance impact on high TPS servers. I've seen it and discounted this technology for...

This is why...

Agreed

This is a very similar way to me except I always wanted to work in IT but circumstances...

ananda.murugesan (9/10/2012)

---

OS - Windows 2008 R2 64 bit (no service pack installed on operating system level)

SQL - SQL SERVER 2008 R2 64 bit (SP 2 installed)

One of the dedicated sql...

Of course my suggestion assumes the rows can be in different states whilst the update is ongoing.

If the rows need update simultaneously I would do this

1. create a...