D'oh, should have thought about that.

I've just had a look at the query and it doesn't look like it ran in parallel but that would explain it. I'll go...

I'd guess that you have a query still executing which is preventing the log from being cleared

SQLHeisenberg (8/4/2015)

---

Hi,

If you put your databases on Ephemeral storage on EC2 instance, then you will lose all your data on that storage after instance restarting. One solution will be to...

Darn, didn't read the title!

How many times have you sat an exam and the examiner has stressed that...

Sean Lange (7/16/2015)

---

Another thing to do in Seattle...of course the NW is known for having lots of microbreweries but what often goes unmentioned is that many of them also make...

Jeff Moden (7/16/2015)

---

It's a lot of fun. I had a great time...

The underground tour looks amazing (as you said Steve), booking a ticket on that

Sean Lange (7/16/2015)

---

Greg Edwards-268690 (7/16/2015)

---

Sean Lange (7/16/2015)

---

DBA From The Cold (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

DBA From The Cold (7/16/2015)

---

BrainDonor (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does...

Brandie Tarvin (7/16/2015)

---

DBA From The Cold (7/16/2015)

---

BrainDonor (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy...

BrainDonor (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy herself in Seattle during the daytime?...

I'd use powershell to do this:-

$date = get-date -format ddMMyyyy_hhmmss

$filename = "DBCCResults_" + $date + ".txt"

sqlcmd -U backup -P Password -S Server -Q"DBCC CHECKDB('DatabaseName') WITH ALL_ERRORMSGS" -o"G:\LOGS\$filename"

Grant Fritchey (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Grant Fritchey (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please as I know pretty...

Grant Fritchey (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please as I know pretty much all of you are writers/bloggers.

I've...

GilaMonster (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

GilaMonster (6/30/2015)

---

Koen Verbeeck (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please as I know pretty...

GilaMonster (6/30/2015)

---

Koen Verbeeck (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please as I know pretty much all of you are...