Viewing 15 posts - 18,346 through 18,360 (of 22,202 total)
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...
February 16, 2009 at 6:48 am
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....
February 16, 2009 at 6:46 am
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...
February 16, 2009 at 6:18 am
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,...
February 16, 2009 at 6:05 am
Ken Gaul (2/16/2009)
February 16, 2009 at 5:57 am
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...
February 14, 2009 at 12:24 am
I'm with you on this one. If it's "too big to fail" time to tear it right the f' down now.
February 14, 2009 at 12:21 am
Florent Rousseau (2/13/2009)
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...
February 13, 2009 at 11:07 am
GSquared (2/13/2009)
(I can legitimately and truthfully claim that I dropped out of both kindergarden and college. Not many with those...
February 13, 2009 at 9:30 am
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).
February 13, 2009 at 9:11 am
Lynn Pettis (2/13/2009)
If that isn't what the OP meant,...
February 13, 2009 at 8:55 am
GilaMonster (2/13/2009)
Grant Fritchey (2/13/2009)
There's a blog post. Do you get it or do I?
Why not both? (Like we did with the table-valued functions)?
I'll write one over the weekend. Title's...
February 13, 2009 at 8:44 am
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.
February 13, 2009 at 8:43 am
Lynn Pettis (2/13/2009)
No. Running the query above prior to creating the clustered index will have no affect at all on the create index statement.
Actually won't it slow everything down?...
February 13, 2009 at 8:41 am
sam (2/13/2009)
February 13, 2009 at 8:34 am
Viewing 15 posts - 18,346 through 18,360 (of 22,202 total)