If you can, post an actual execution plan for the query. Also, if you can, post the structure of the tables, especially any indexes on them. Too few, too many,...

Ken Gaul (2/16/2009)

---

Yeah I did think of that but presumably if I'm happy with the parameters I optimize for will give me a good(ish) plan every time then it is...

I've got to agree with Lynn. Have you tried combining the second query with the first? There doesn't seem any reason to keep them seperate. Once they're combined, I think...

I'm with you on this one. If it's "too big to fail" time to tear it right the f' down now.

Florent Rousseau (2/13/2009)

---

Hi,

I also use some dynamically written queries and also ran into the limit of the maximum string length (VarChar(8000)).

I solved it by cutting down the whole query in...

GSquared (2/13/2009)

---

I'm a kindergarden drop-out. Does that count for anything?

(I can legitimately and truthfully claim that I dropped out of both kindergarden and college. Not many with those...

I don't have a Bachelors. So there!

And I don't have a single certification (well, a 14 or 15 year old one from Sybase, but I'm pretty sure that doesn't count).

Lynn Pettis (2/13/2009)

---

What I think he was asking, will the create index run faster after I run the query with the order by first.

If that isn't what the OP meant,...

GilaMonster (2/13/2009)

---

Why not both? (Like we did with the table-valued functions)?

I'll write one over the weekend. Title's...

Two options. First, UNION all three statements together. Then you'll get all the James data.

Option 2, check for @@ROWCOUNT to see if you have any data with an IF statement.

Actually won't it slow everything down?...

sam (2/13/2009)

---

Thanks for the reply Grant! I really appreciate it. So pretty much if I want to stick with using the linked servers then I need to incorporate...

GilaMonster (2/13/2009)

---

Sorry, shouldn't have used the term 'estimated'. I seem to have confused everyone. I'll explain better.

The terms estimated and actual for plans are actually a bit of a misnomer....

Grant Fritchey (2/13/2009)

---

Yeah, that's how you get the actively executing plan. It must show the estimated plan while executing... I can't find documentation that says it would show the estimated...

Yeah, you're probably running into schema issues. If the schema defining the object is anything other than the default schema for the connection, you can't simply call the proc.