Table variables don't have statistics. That's probably the issue based on how you're using them in JOIN's. Try doing the same thing with temporary (#temp) tables and see if it...

You may have an index, but is it getting used? Have you looked at the actual execution plan? Can you post it?

GSquared (9/18/2009)

---

I must be doing something wrong. ...

Assuming you're talking about a situation where you're running SELECT... SELECT... SELECT... SELECT... and you're not putting all kinds of IF logic in there, then yes, running all four at...

Yep, sorry, parsed this sentence multiple times and I'm still confused.

Could you explain in a bit more detail what it is that you're trying to do?

Jim-1146873 (9/17/2009)

---

Hi,

Can anyone help me out how to take a backup of a database between a specified duration.

For ex, i want to take back up between August 1st 2009 and...

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye out as...

Jeff Moden (9/17/2009)

---

To the rest of you folks, I just want to say "Thanks" for backing me up. I've been under the weather and in bed for the last...

She hasn't been here recently, but she's still about. She posted a comment over on my blog recently (fixing...

lmu92 (9/17/2009)

---

Grant Fritchey (9/17/2009)

---

Actually, I think that one was just a misunderstanding. He didn't get that Jeff was showing him how to set up a test for his index... I...

Seth Lynch (9/17/2009)

---

sanjeev_krs2004 (9/17/2009)

---

Hi -

Its just a simple maintenance plan where I am rebuilding indexes, reorganizing indexes, shrink database...etc. All the usual stuff. Secondly, I am not sure but...

lmu92 (9/17/2009)

---

Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste won't work...

Silverfox (9/17/2009)

---

Grant Fritchey (9/17/2009)

---

From what I can see, it looks like REPAIR_DATA_LOSS has fixed the issue (at what cost, you have yet to find out). What problem are you having...

Yeah, I guess I didn't say it my post, it's fine to index a VARCHAR column, but you need to test, test, test. The same goes for any index on...

The view all by itself isn't the issue. It really is about caching the plan and caching the data. From the sounds of it, your data cache is well and...