Are you doing a complete refresh of the data every time? If so, you might want to consider getting an incremental process in place.

Structurally, another way to speed this up...

Pretty much, you have to have a valid backup, the privileges on the server, and enough space to support the backup. That's about it. What were you looking for?

Minimum once a year during our annual power down, but in general we try to keep them up as long as possible. In practice, it's probably 2-3 times a year...

GSquared (7/1/2009)

---

Grant Fritchey (6/30/2009)

---

GSquared (6/30/2009)

---

GilaMonster (6/30/2009)

---

GSquared (6/30/2009)

---

No more waiting...

That's a pivot operation. Do a search on it. I'm not great at them, so you'd be better off looking up what the real experts have to say.

Gianluca Sartori (6/30/2009)

---

GSquared (6/30/2009)

---

I read and mostly understood Frank Herbert's "Dune" when I was seven. I've been playing with the English language ever since, and it's quite a toy!...

GSquared (6/30/2009)

---

GilaMonster (6/30/2009)

---

GSquared (6/30/2009)

---

No more waiting required. Let...

I ain't singing and I ain't dancing, but I will take one of those particle accelator things please.

Heh. You really were skipped right by. Shame since you had the answer PDQ.

That looks like you're on the right track to me.

By the way, it's kind of a waste of space & time & readability to put 'tbl_' in front of table...

Well done Ken!

All those scans converted to nice seeks. Looks good.

I was never aware of a particular sweet spot in terms of compiles to batches. The fewer the better was the only rule I operated under.

jcrawf02 (6/30/2009)

---

Paul White (6/30/2009)

---

When I first read that, it sounded...

TheSQLGuru (6/30/2009)

---

1) I would imagine (hope) that the optimizer would choose the 'most-compact' covering index in the case where multiple indexes cover a query.

2) DTA and the missing index subsystem...

I agree. I wouldn't add that data to your Names table. You should go for a more normalized approach with a Subjects table and, like the last post said, a...