My thanks to Lowell!

Using your Delete commands, plus adding one to delete from dbo.sysmail_mailitems, the DB is down to about 23GB from 133GB!

Set up an Agent job to run once...

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're using. And it's awfully hard to...

Good article, and I've forwarded it on to one of the Supervisors here as suggested reading for staff...

But, in the last section, in the sentence:

When I was in college, one...

While it was a bit of snarky reply, it's also true. If you want to automate something like this, it's going to have to be scheduled somehow. Either...

Lowell I'll give those a try once my re-restore of the DB on my test box completes...

It only takes about an hour-and-a-half or so to restore...

😉

Thanks!

Jason

Brandie Tarvin (10/17/2012)

---

dwain.c (10/16/2012)

---

Perhaps he was so focused on the future he's never interested in...

Aw yeah!

Just one more win to go for the Tigers!!

I think I'm seeing brooms tomorrow!

😀

Actually, even if they back it up with compression, you can restore it. I tested this recently here at my work, as we have clients who (tightwads) use SQL...

Your best bet to get the best answer, is going to be to contact a Microsoft Licensing specialist. I'm presuming your using Volume Licensing, in which case here's the...

Not looking good for the As' at this point.

Top of the 7th, Tigers have knocked in 3 runs with the bases loaded (and they're still loaded) with 2 outs...

SQLRNNR (10/10/2012)

---

He is also the type that thinks you are unprofessional if you crack a joke during a presentation. Then he rips you apart on the speaker survey for...

Brandie Tarvin (10/10/2012)

---

jasona.work (10/10/2012)

---

WayneS (10/10/2012)

---

Steve Jones - SSC Editor (10/9/2012)

---

jasona.work (10/5/2012)

So *YOU'RE* the reason the wifi packed it up after the first 15 minutes!

All joking aside, I did enjoy the...

WayneS (10/10/2012)

---

Steve Jones - SSC Editor (10/9/2012)

---

jasona.work (10/5/2012)

So *YOU'RE* the reason the wifi packed it up after the first 15 minutes!

All joking aside, I did enjoy the SQL in the...

Cliff Jones (10/8/2012)

---

JAZZ Master (10/8/2012)

---

Daniel Bowlin (10/8/2012)

---

American...

OK, the broadcasting of the games is shaping up to be a real suck-fest...

TBS gets most (all) the games, and because they can only show so many, yesterdays Tigers /...