You have to be careful with OUTER JOINs and column references in the WHERE clause.

If you reference a column from the NULL-extended table, in a way that eliminates columns containing...

These sorts of issues with Agent Jobs are almost always down to the account context that the job is run under, or problems with impersonation. See:

Implementing SQL Server Agent...

As the question is written (and as is usual for this sort of requirement) only a LEFT (or RIGHT) OUTER JOIN is required.

SQL Server 2008 also contains some advanced optimisations...

Because SQL Server will not run without one 🙂

The transaction log records absolutely every change made to a...

Gary7512 (5/28/2010)

---

The backup uses VSS which takes a shadow copy of the drives and works around the issue of locked files. However, I have not actually tested restoring a sql...

Yes definitely worth testing.

Moving...

Indianrock (5/28/2010)

---

Did I understand correctly that if you went to bulk logged ( or simple?) before reindexing, you could then resume full recovery and log backups afterwards without doing...

Stefan Krzywicki (5/28/2010)

---

Heh, I'd love to see...

Kevin Landry (5/28/2010)

---

I have also considered the Bulk-Logged option, but I do not see how switching to Simple is any more dangerous than using the Bulk-Logged option?

Switching to any other...

James_DBA (3/17/2010)

---

To start off with an improperly sized log file such as that of which you are describing can actually hurt your performance in a magnitude that is unacceptable. You...

My personal view on all this is that transaction log auto-growths are there only as a last resort.

It makes sense to me to over-size the transaction log initially (while being...

James,

There are a few things from the article I'd like to comment on directly:

How about the times you need to grow your log? I did a recent search and had...

Kevin Landry (3/29/2010)

---

Most of the issues that I see on Transaction Log File growth are due to the recording of index rebuilds. Meaning, with the FULL recovery model, whenever there...

Alberto De Rossi-378909 (7/16/2009)

---

I'm Triyng to autogrowth a log file. A created a DB witn one table with a couple of char 8000 fields, inserted many, many rows. But the...

Good enough explanation for me. Funny about the confusion over Dave's signature.

I retract the 'lazy' comment, partially. Clearly Maddy made a lot of effort was made to solve...