Viewing 15 posts - 16,171 through 16,185 (of 22,221 total)
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
I had a decent rib eye at a steak house in Gettysburg on Friday after a 10+ mile hike with the Scouts covering about 2/3 of the Union lines 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 23, 2009 at 8:14 am
Paul White (11/17/2009)
LMGTFY version 2.0:
I'm confused now. Shouldn't that be LMBTFY?
"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 17, 2009 at 5:24 am
GilaMonster (11/16/2009)
Grant Fritchey (11/16/2009)
Direct from the horses mouth, the 1000 page number is arbitrary, not based on emperical evidence.
According to Paul, it was an estimate based on knowledge of...
"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 16, 2009 at 8:49 am
GSquared (11/16/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 16, 2009 at 7:50 am
It's a little hard to see the data breakdown on the columns you have posted, but if I'm reading it right, the most fragmented index only has 3 pages. This...
"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 16, 2009 at 7:11 am
Viewing 15 posts - 16,171 through 16,185 (of 22,221 total)