Viewing 15 posts - 16,171 through 16,185 (of 22,226 total)
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
Bru Medishetty (11/24/2009)
john.arnott (11/24/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 6:22 am
CirquedeSQLeil (11/24/2009)
Bob Hovious 24601 (11/24/2009)
In order to avoid redundancy and repetition and redundancy, we have established an informal rule that newcomers first...
"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:21 am
Bob Hovious 24601 (11/24/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 24, 2009 at 10:45 am
Bob Hovious 24601 (11/24/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 24, 2009 at 8:51 am
john.arnott (11/23/2009)
I'd always heard that Irish Coffee was the perfect food as it comprises all of the major food groups:Alcohol
Sugar
Caffeine
I can't help myself
Where's the beef?
"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 23, 2009 at 11:34 am
GilaMonster (11/23/2009)
Grant Fritchey (11/23/2009)
Yep. Gail nailed it (shocking I'm sure).Just finished writing a blog post on 'optimal' join types. Virtually a copy-paste from blog to forum.
Excellent. I'm still catching up...
"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 23, 2009 at 9:19 am
Yep. Gail nailed it (shocking I'm sure).
With absolutely nothing to differentiate them, the engine is going to pick one... it has to. But you never know, there might be a...
"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 23, 2009 at 8:44 am
Alvin Ramard (11/23/2009)
Grant Fritchey (11/23/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 23, 2009 at 8:40 am
Viewing 15 posts - 16,171 through 16,185 (of 22,226 total)