Almost nothing, which is why the Express edition can perform this task. It's only there to form a quorum, so it's role is really to tell server A whether...

nadabadan (1/27/2011)

---

And that's quite a bit more than "... if you just want to see the content of a long field then the easiest way is to copy the value...

nadabadan (1/27/2011)

---

DECLARE @v-2 varchar(max)

DECLARE @t varchar(max)

SET @t = 'abcdefghij'

SELECT @v-2 = REPLICATE( @t, 10000 )

SELECT @v-2

If you copy and paste the value in the...

nadabadan (1/27/2011)

---

matt stockham (1/27/2011)

---

All valid techniques, but if you just want to see the content of a long field then the easiest way is to copy the value (ctrl-c) from...

All valid techniques, but if you just want to see the content of a long field then the easiest way is to copy the value (ctrl-c) from the cell and...

You may want to check your wait stats during a test to see what the delay is.

Ninja's_RGR'us (5/10/2010)

---

Is it safe for me to enable the transaction level on the db (without changing any code)?

(Yes I'll test on preprod server to confirm)..., but are there any adverse...

Chandu-212374 (4/29/2010)

---

Our production database on SQL 2005 has grown to a size of around 800 Terabytes of data and transaction log is around 100 TB. We have set the frequency...

I looked up that log message and found http://support.microsoft.com/kb/937041

So you can force replication to continue with the trace flag if you have that CU or are on SP3. I...

Jason Shadonix (4/28/2010)

---

aqkhan_k (4/28/2010)

---

Since the mirror is not available and the transaction on principal are not committed therefore transactions will not be replicated.

But when the Mirror comes back online,...

Yes, it will connect but there are a few tree nodes in the explorer that won't be available - pretty much any of the new functionality.

It shouldn't matter - as long as the witness is available (if you are using one) then the principal will continue to create log entries.

Here are a couple of documents that will help you understand the issues. Being as the decision already seems to have been made, and the hardware purchased, I would...

Most likely the two servers will become unsynchronized for the duration of the outage, and sync up when they can talk again. The bigger concern would be that the...

More threads = more memory usage, more CPU required, and of course the number of cores will limit the number of concurrent active threads. If the threads can't do...