Viewing 15 posts - 16,141 through 16,155 (of 22,213 total)
Whatever context SQL Server is running under, it does not have access to that network share. Even if you do, and you're running the command, it doesn't matter, the SQL...
December 2, 2009 at 6:14 am
When you insert a row, it has to be placed in the correct place in an index. When you do a batch insert of umpty-x number of rows, they also...
November 30, 2009 at 8:44 am
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
Viewing 15 posts - 16,141 through 16,155 (of 22,213 total)