Perry Whittle (4/29/2010)

---

Lynn Pettis (4/29/2010)

---

Since you are not using a witness, if the mirror databaseis unavailable, the transactions will get committed on the principal database. This will start approximately...

Also make sure there isn't a firewall that is blocking the TCP port SQL is running on. (1433 by default)

winston Smith (4/29/2010)

---

This is the information i required. thanks a mil. This causes an issue to us because we replicate a large amount of data to related systems, which allows...

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, the transactions...

Miron Berlin (4/24/2010)

---

* To cover bases we need to add to this article performance data for compression + encryption. It needs to be more generic in terms of CPU I/O...

dave-dj (4/26/2010)

---

Hi Jason,

The last post dissappointingly answered a question I had. My other question though, is what process would you recommend for upgrading SQL 2005 servers that are taking...

Mike Byrd (4/23/2010)

---

Good article and glad to see numbers attached to it.

One question, though, when you apply row or page compression is the table (and its respective indexes)...

Mine is that way too. Another interesting thing...if you click on it, the little "tool tip" thing that shows up says: "Indicates whether this 32-bit service is running on...

David Walker-278941 (4/22/2010)

---

sknox (4/22/2010)

---

Ah, yes, that does make sense. Still, it would be useful to know what the "units" are on the Time scale.

I think that with a lot...

dma333 (4/22/2010)

---

Great article. I'd like to see more about how query performance was affected. Also, when backing up a compressed table to a compressed backup, is that faster...

ben.rosato (4/22/2010)

---

I have a table that's 10GB. There is a ntext column that holds the largest portion of the data. When I check the estimated compression for this...

Doh! I've missed three in a row now. Good one though!

shinobigoh (4/13/2010)

---

I have a problem

My sql server 2000 database crashed but data files are still there.

I want to reinstall the sql server 2000 on a new hard disk and want...

Phil Parkin (4/15/2010)

---

Max worksheet size is 1,048,576 rows by 16,384 columns in Excel 2007.

The fact that there is no explicit column data-typing in Excel is the single biggest cause of...

Interesting thought...It just occurred to me that more...