Viewing 15 posts - 16,186 through 16,200 (of 22,231 total)
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
GilaMonster (11/10/2009)
Jack Corbett (11/10/2009)
She seems to be spending her day today correcting my answers.:-P
Sorry. Will be leaving now. (cause battery's low and ADSL still needs configuring. maybe a Hammer will...
"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 10, 2009 at 7:58 am
GilaMonster (11/10/2009)
Still got to configure ADSL and redo the entire wireless network. That'll teach me to change ISP while...
"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 10, 2009 at 7:57 am
Paul White (11/10/2009)
TheSQLGuru (11/9/2009)
Yeah - this was your IMPROVED design, right?? LOLLMAO!!! :laugh:
You guys kidding? This app has had more examples of bad design than any I've seen. It...
"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 10, 2009 at 6:28 am
rshm35 (11/9/2009)
The query has 12 joins in that 2 views are there...i can not use indexed view..help me out..
You've got to answer the questions that we've been posting back. We...
"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 9, 2009 at 5:13 pm
Paul White (11/9/2009)
Grant,86? :w00t:
Paul
Not my design, man, not my design.
"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 9, 2009 at 5:11 pm
Viewing 15 posts - 16,186 through 16,200 (of 22,231 total)