Viewing 15 posts - 3,766 through 3,780 (of 4,080 total)
Please post schema of the tables involved and the code being used to do the insertions, and perhaps someone can help you.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 9, 2009 at 12:58 pm
I appreciate your giving it a shot and giving me a reply, Jack.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 9, 2009 at 9:50 am
If it walks like a duck....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 8, 2009 at 6:30 am
Okay... I see it now.
What version of Sql Server are you running on?
Will it let you use the ROOT option with your FOR XML? EX: ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 7, 2009 at 7:51 pm
can't see anything....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 7, 2009 at 3:57 pm
Could you please post up a short script creating a temporary table with an XML column and posting a sample of your XML into it? The article...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 7, 2009 at 11:33 am
I've been using INSERT INTO for so long that I forgot INTO was optional. Who knew?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 7, 2009 at 11:26 am
Seth, if you look at the execution plan, even visually, can't you see where the exclusions are happening in the process?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 7, 2009 at 10:45 am
Or not 🙂 You've already fixed the problem.
I was just curious if the optimizer would generate a different query plan with your live data.
Hope...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 7, 2009 at 9:39 am
http://www.sqlservercentral.com/Forums/Topic651773-338-1.aspx
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 6, 2009 at 3:56 pm
Give this a try at least. It runs faster with your test data.
I use glue tables all the time too... but always in this format:
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 6, 2009 at 3:03 pm
http://www.sqlservercentral.com/articles/Best+Practices/61537/
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 6, 2009 at 2:31 pm
Guys, I've never seen a table joined against two different tables before. Do you do it a lot?
Just a hunch, but have you tried getting the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 6, 2009 at 2:29 pm
http://www.sqlservercentral.com/articles/Best+Practices/61537/
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 6, 2009 at 2:17 pm
I was getting 1 million rows in 8.5-9.5 seconds on my laptop without precalculation, but 4 ms for a single row. So faster in batch, but slower in...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 6, 2009 at 1:09 pm
Viewing 15 posts - 3,766 through 3,780 (of 4,080 total)