WayneS (4/17/2010)

---

Steve, surely you've seen...

If the queries are starting to take more time, it could be that your statistics are getting out of date. Do you have a maintenance plan for maintaining them? It's...

Yes, Michael's on top of this. If a SQL Agent Job is actively running, you cannot call it and start it again.

jabadwy (4/16/2010)

---

We have prob over 30 indexes in total on our db where DTA has recommended using clustered index on covering index or as include - i am concerned that...

Microsoft offers a tool called the Upgrade Advisor. You need to track down a copy of this. It's available online. It will walk you through most of the process of...

Jack Corbett (4/16/2010)

---

WayneS (4/16/2010)

---

Hey Jack, how...

Jack Corbett (4/16/2010)

---

Grant Fritchey (4/16/2010)

---

dma-669038 (4/16/2010)

---

Grant Fritchey (4/16/2010)

---

dma-669038 (4/16/2010)

---

Learning how everything is supposed to work as opposed to all the ways you can screw it up will teach you...

dma-669038 (4/16/2010)

---

Grant Fritchey (4/16/2010)

---

dma-669038 (4/16/2010)

---

Learning how everything is supposed to work as opposed to all the ways you can screw it up will teach you many ways to screw...

Ray K (4/16/2010)

---

Yep, we had this conversation before. Looking forward to finally meeting...

dma-669038 (4/16/2010)

---

I am missing something here, i do read a lot of the tsql posts, not every single one but quite a few (need to find more time to respond...

Me too.

Wayne nailed it. Don't hit the green arrow, despite how tempting it looks.

Bare minimum, you have...

You have to ask?

Joking aside, I like SSC for SQL. But there's more to life...

Yeah, mine didn't used to work, but now it does. I wish I could tell you what I did, but I didn't do anything.