Viewing 15 posts - 16,156 through 16,170 (of 22,219 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:41 am
GilaMonster (11/25/2009)
Atul DBA (11/25/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:38 am
roelofsleroux (11/25/2009)
If the database fails for some reason, the mirror kick in. If there is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:36 am
Nope. It's going to execute them one after the other and combine the data.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:33 am
Without looking at the efficiency of the query, it's pretty easy to explain why you would see a difference between these two. A SELECT statement just pulls the data. When...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:31 am
However, once you have a set based process (and yes, please do this first), yes, usually when doing large scale data loads I've found that dropping the index and recreating...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:28 am
To a degree you're going to get what you pay for. You can bounce around the internet and you're going to find fantastic articles and blog posts, but they're not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 7:14 am
I wasn't aware that using the correct data type for a given value was "old fashioned"... well, OK, with all the horrific tables coming out of these ORM tools, maybe...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 6:48 am
Viewing 15 posts - 16,156 through 16,170 (of 22,219 total)