I wouldn't suggest you empty the table, create the index and then load the table. That's actually the opposite of how most large scale loads are done. Instead, get every...

I wouldn't call it a tutorial, but I did write up my experiences doing this sort of thing. It will give you an idea of how you could approach it....

I think you're referring back to another set of posts where someone suggested that using the IN clause in the query eliminated the need for the DISTINCT clause. Am I...

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...