And with some of the OP's, that is what I do. What usually happens, though, is just as you say; someone else comes along and just provides an answer,...

GSquared (8/27/2009)

---

Lynn Pettis (8/27/2009)

---

I may agree to a point.

Asking this:

tells me you haven't even tried to find an answer yourself and...

2 Tim 3:16 (8/27/2009)

---

I believe as soon as you take a Snapshot of your mirrors or have any DB in a readable state, (whether you are using them or not)...

Show us. I can't tell you anything based solely on the description of the problem. It would also help to post the DDL, including indexes, for the table(s)...

I may agree to a point.

Asking this:

tells me you haven't even tried to find an answer yourself and want someone else...

Point of the question was actually to have you show us what you have tried. Post your code.

And what have you done to try and solve this problem?

It Depends. Not being familiar with your systems I can't really answer that question.

Please define what you mean by Julian Date. Sorry, but I have seen systems that have used that term and the Julian Date was a home grown representation.

Don't shrink your databases or the logs, unless you have done some one off processing that may have resulted in excessive growth of the log or significantly decreased the amount...

I can purchase a single license of SQL Server 2005 Enterprise Edition and install it on two servers as long as the second server is a "passive" failover, either as...

You are going to need some down time, even if it is just a cople of minutes in order to rename databases to effect the swap of data.

Unless SSC happens to be on the critical path for the work they are doing. 😉

Still, after numerous questions that could be answered by a little work on their...

Blocking the checkpoint seems logical to me. Ensures a consistant backup of the transaction log.

Now to this one. This individual really needs to figure out how to open and read BOL.