I suggest two more things before starting any of that.

1. Backup the database

2. Disable access to the server for all connections not related to you, the team, or...

John Langston (3/17/2010)

---

If each CIO (or equivalent) were required to sign a statement on a 10-K that current patch levels had been met as of the document date, I suspect...

Lynn Pettis (3/17/2010)

---

john.arnott (3/17/2010)

---

gamcall (3/17/2010)

---

"So if the insert transaction completes after the full backup is complete, how many rows where inserted till the backup gets completed will be included in...

Alvin Ramard (3/17/2010)

---

No, but why don't you use TimeWarp to go forwards to the day he comes back and see what he...

Has anybody heard any news about Barry's surgery?

lmu92 (3/17/2010)

---

CirquedeSQLeil (3/17/2010)

---

That should stir up plenty of controversy. ...

No - tables don't need a clustered index because that causes invalid data returns.

Have you tried the steps in the following article?

http://msdn.microsoft.com/en-us/library/ms190438.aspx

That should stir up plenty of controversy. Maybe it...

I recommend that you use a script such as the one that Michelle Ufford has developed. You can find it at her blog at http://sqlfool.com/.

It performs a smart index...

In addition to that reading, look up SSRS NLB (network load balance). You can install ssrs on a cluster box but would need to make SSRS a member of...

Highly probable.

Fair enough

The Dixie Flatline (3/17/2010)

---

Jason, I hadn't planned on a sequel. No pun intended. Right now I have another writing commitment to honor before I can do...

homebrew01 (3/17/2010)

---

CirquedeSQLeil (3/17/2010)

---

homebrew01 (3/17/2010)

---

Brandie Tarvin (3/17/2010)

---

Thirdly, you can implement the use of DDL statements in your code to prevent this happening in the future. That way, it'll refuse to make...