I'd say the first thing to do, is see what SQL says is the reason for not re-using the log space:

use [master];

select name, log_reuse_wait_desc from sys.databases;

Could be a long-running transaction,...

The rule of thumb would be to set it large enough that it doesn't need to grow, with a little headroom to handle "bursts" of transactions.

It's the sort of thing...

Nuns

jcrawf02 (8/2/2013)

---

we'll send you some fresh cream, and you can enjoy...

Steve Jones - SSC Editor (7/31/2013)

---

As of now, most of the last year has been spent on Simple Talk, which had a very creaky, and cumbersome platform. This one, whilst...

I didn't even really notice, I guess because...

A couple months back, I changed jobs...

My new employer uses (and has been using) CommVault for several years to handle all the backups, and here's what I've seen / discovered...

Jeff Moden (7/26/2013)

---

BWAAA-HAAA!!! I've got tons of hair. I'm just not allowed to show it...

Virtualization tech: Whatever you're comfortable with

OSes: Licenses for the virtualization depends on what you go with, both MS and VMWare have free options. Guest OSes again will...

As long as you stay stingy on the disk space granted to a VM, you could probably get away with doing this with a virtualization server with a single 2TB...

OK, I now want to try set-based TV watching...

Anyone got a couch I can sleep on when the wife kicks me out for it? I figure if I use...

Stefan Krzywicki (7/24/2013)

---

jcrawf02 (7/24/2013)

---

Koen Verbeeck (7/23/2013)

---

Probably, if I wasn't already...

Another option if you don't want to mess around with undocumented SQL commands, would be to look into using the DOS command FORFILES. At my previous job, I had...

Nope. You still would need to (if you deem it worth the time and effort) go back and compress the non-clustered indexes.

Having just dealt with compressing a table with both clustered and non-clustered indexes:

i) I don't believe so. I believe you can compress just the indexes, but you probably...