Viewing 15 posts - 16,141 through 16,155 (of 22,211 total)
Does it have different session id's? I'm just curious if it's opening a second connection to run the query. But yeah, I've seen it before. We had an app that...
November 30, 2009 at 8:30 am
Sounds like you're running a cursor. But I'm honestly just guessing without code.
November 30, 2009 at 7:54 am
Connection settings differences makes the most sense. Especially the ANSI standard settings. Differences there will absolutely result in different execution plans.
November 30, 2009 at 7:10 am
Previously, I just concentrated on blocking stuff out. Lately, I've been listening to music a lot. Neither approach is perfect. I'd love to try out the noise cancelling headphones with...
November 30, 2009 at 7:07 am
Since it's a temp table, what does your tempdb look like? Are you possibly seeing a lot of resource contention there? Do you have multiple file groups (and drives) assigned...
November 27, 2009 at 5:39 am
RBarryYoung (11/25/2009)
Grant Fritchey (11/9/2009)
...Best thing was showing up late to Buck Woody's session, in a kilt. I sat up front... Sharon Stone was mentioned... 'nough said.
BWAHAAHA!!! OMGROFL! :w00t:
...
November 27, 2009 at 5:23 am
GilaMonster (11/25/2009)
Happy normal working week. 😀I'll hold down the fort while all the US people are off stuffing themselves with turkey and whatever else appears on a thanksgiving table.
More apple...
November 25, 2009 at 1:38 pm
Ah, Thanksgiving. The day we in the US celebrate getting kicked out of all the good countries and surviving the process.
Last time I was in England during Thanksgiving. I said...
November 25, 2009 at 1:09 pm
GilaMonster (11/25/2009)
Bru Medishetty (11/25/2009)
Thanks Grant for the link, had a nice time reading the thread and of course something about outages / disasters in South Africa.
We don't have lots...
November 25, 2009 at 12:41 pm
The XML isn't the cleanest in the world.
I did eliminate the CROSS APPLY as you suggested, but it's not seriously impacting performance. I'm just bummed because I told everyone and...
November 25, 2009 at 11:35 am
Is it consistently the same time or does it vary. You might be hitting contention on the inserts.
November 25, 2009 at 11:08 am
Jeff Moden (11/25/2009)
Grant Fritchey (11/25/2009)
GilaMonster (11/25/2009)
As your log file is very huge, and it is...
November 25, 2009 at 8:56 am
GilaMonster (11/25/2009)
As your log file is very huge, and it is required to Truncate the...
November 25, 2009 at 7:59 am
roelofsleroux (11/25/2009)
Gila you sound like Doomsday Prophet. This is South Africa. The only natural disaster we know of so far is a flood 21 years ago that destroyed a town....
November 25, 2009 at 7:57 am
Alvin Ramard (11/25/2009)
Roy Ernest (11/25/2009)
I sometimes feel that the thread rules us... We dont rule the thread anymore. It has evolved itself into a controlling being
To the new folks in...
November 25, 2009 at 7:41 am
Viewing 15 posts - 16,141 through 16,155 (of 22,211 total)