Viewing 15 posts - 3,766 through 3,780 (of 4,081 total)
I may have to try some of those on Joseph (*URGENT*URGENT*URGENT*) Tran.
February 9, 2009 at 1:03 pm
Please post schema of the tables involved and the code being used to do the insertions, and perhaps someone can help you.
February 9, 2009 at 12:58 pm
I appreciate your giving it a shot and giving me a reply, Jack.
February 9, 2009 at 9:50 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: ...
February 7, 2009 at 7:51 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...
February 7, 2009 at 11:33 am
Seth, if you look at the execution plan, even visually, can't you see where the exclusions are happening in the process?
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...
February 7, 2009 at 9:39 am
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:
...
February 6, 2009 at 3:03 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...
February 6, 2009 at 2:29 pm
Viewing 15 posts - 3,766 through 3,780 (of 4,081 total)