Jack Corbett (8/4/2010)

---

The problem in this case is that I do need the INNER JOIN conversion because without it I'd get rows I don't want, but there are rows that...

Uh-huh. Sounds to me like you're trying to get Jack to write an article so that YOU...

No. Partially because you didn't include create scripts for your tables so that I could actually test it. @=)

But...

Chances are you were having network troubles when the job tried to complete. It could have been anything from noise to inaccessibility. Try the job again, while you're sure the...

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the OUTER JOINs...

Are you using anti-biotic salve or a general "good...

Can you open up remote desktop, hit your dev server, and open up SSMS that way?

If so, I tend to agree that there might be something going on with the...

Apparently you didn't read the first line of the second article.

Real life...

Are you backing up to a network location? If so, check and make sure your destination still exists.

Best practice is to backup locally and move a copy of the backup...

I'm going to say yes. Even if C: and D: are separate physical drives instead of logical drive partitions on the same drive, SQL Server puts registry keys into the...

Grant Fritchey (8/4/2010)

---

Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old...

A note of interest. One of our more SAN-Experienced DBAs told me a few months ago that a SAN might also only have one controller, no matter how many physical...

Animal Magic (8/4/2010)

---

the reason i need live data to be refereshed on a daily basis is because often when testing the users will want to use the same data that...

GilaMonster (8/4/2010)

---

Brandie Tarvin (8/4/2010)

---

"Blocking" isn't a simple issue to assist with on the forums. Once you track down what's being blocked, you can start troubleshooting to find out what it's...

What do...