When I...

You are welcome, John. I might also advocate adding another drive to the server and moving the log file there.

(1) It will get that pesky log file out of...

john.leo (7/8/2008)

---

I'm still not clear why SQL Server doesn't auto shrink the transaction log when a full backup is done in the full recovery model. No transaction logs are needed...

Other than a formatting issue (narrow code window) I found this a good reminder about something I'm just about to do.

I'm revising a data archive procedure. Somethings don't need...

Thanks Stephanie. They say that you learn something new everyday.

Stephanie

Your analogy is valid, correct, and well stated. It is possible to turn it off, however. Set recovery mode to simple and nothing gets logged. In that...

Good article James. I gave you 4 on it. Please consider expanding it a bit.

Did you know that SQL Server actually writes everything to the log first and...

steve.lambert (7/2/2008)

---

In other databases engines i have been able to translate the log to text in order to aid with fault finding. Is this possible with MS SQL Server. i.e...

The down side of...

godoyd (6/23/2008)

---

I would add to this understanding of not only GUI interface but also command line. not having command line skills i think can be a weakness when the...

So then Joe Celko would be required reading. His style book has way more than just style.

Right on Rudy! I like Phil's observations as well.

I'm a developer who has to be a DBA. One of the coding mantras I often quote is,...

Good article. Where can I get a list of all the objects, properties, and methods?

We recently installed a new drive on one of our SQL boxes. The boss...

Here is yet another reason to avoid cursors altogether. I just got a link to this knowledge base article (thank you KBALERTZ).

Likewise I have killed all the preview panes in Outlook and don't use Outlook Express for my home e-mail.