Steve Jones - SSC Editor (12/9/2011)

---

I whacked our movie channels to save $20/mo when we got Netflix streaming. A month later my wife was upset with me. Not enough of...

Grant Fritchey (12/8/2011)

---

Hmmm... I'm stumped. I'm not sure why that TOP is in there. But, I don't know that I'd sweat it at the moment with all those clustered index...

Grant Fritchey (12/8/2011)

---

Stefan Krzywicki (12/8/2011)

---

Grant Fritchey (12/8/2011)

---

Stefan Krzywicki (12/8/2011)

---

Brandie Tarvin (12/8/2011)

---

Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of...

Brandie Tarvin (12/8/2011)

---

So with this Redmond report about IT losing jobs this year, and possibly next year, how upbeat or pessimistic are you feeling about the industry?

It's hardly any...

Here are the three plans.

Initial Query is the initial query. It uses views, has an update to change text after the insert and has a TOP (100) PERCENT in the...

GilaMonster (12/8/2011)

---

Stefan Krzywicki (12/8/2011)

---

GilaMonster (12/8/2011)

---

Can you post the plans?

RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a...

Grant Fritchey (12/8/2011)

---

Stefan Krzywicki (12/8/2011)

---

It is a...

GilaMonster (12/8/2011)

---

Can you post the plans?

RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a blog post on...

It is a production server, best I...

May I ask for some assistance here. I have triple checked to make sure I'm not using any views in a query, yet the Actual Execution Plan keeps including a...

Grant Fritchey (12/7/2011)

---

It almost sounds like there might a view involved. You sure they're all tables? If you eliminated the TOP, but you're still getting it in the plans, even...

Steve Jones - SSC Editor (12/7/2011)

---

Jeff Moden (12/7/2011)

---

Revenant (12/6/2011)

---

Jeff Moden (12/6/2011)

---

To be honest, I didn't enter... didn't even try to answer a single question. They wanted a "tweet" from...

Evil Kraig F (12/5/2011)

---

The difference Gail is if you WERE American (or working here) you'd be...

Ninja's_RGR'us (12/2/2011)

---

GSquared (12/2/2011)

---

But I was just quoting Blazing Saddles because...

GSquared (12/2/2011)

---

Ninja's_RGR'us (12/2/2011)

---

Steve Jones - SSC Editor (12/2/2011)

---

Ninja's_RGR'us (12/2/2011)

---

Then why is your server hosted on Oracle?? :hehe:

/walks away to...