Viewing 15 posts - 17,086 through 17,100 (of 22,219 total)
Paul White (6/28/2009)
Grant Fritchey (6/28/2009)
I've got that posted on my cube at work.You have a proper Dilbert-style cube? :w00t:
I'm not sure I'd call it proper since I occupy it, but,...
"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
June 29, 2009 at 4:03 am
RBarryYoung (6/28/2009)
Jack Corbett (6/28/2009)
GilaMonster (6/28/2009)
Lynn Pettis (6/27/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
June 28, 2009 at 7:41 pm
mike_walsh (6/28/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
June 28, 2009 at 7:39 pm
Paul White (6/28/2009)
Grant Fritchey (6/28/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
June 28, 2009 at 7:31 pm
GilaMonster (6/28/2009)
Plus it's one plan per execution of the UDF. Also, you cannot trust statistics IO when you have a udf that does any form of data access.
I'm not sure...
"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
June 28, 2009 at 5:51 am
GilaMonster (6/26/2009)
Grant Fritchey (6/26/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
June 28, 2009 at 5:44 am
David.Poole (6/26/2009)
He has some pearls of wisdom
1. It takes 18-24 months for the agile methodologies...
"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
June 28, 2009 at 5:39 am
mike_walsh (6/26/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
June 28, 2009 at 5:24 am
Once you get the indexes in place, I'd suggest that a TOP with an ORDER BY is going to be more efficient in this situation than the MAX that you're...
"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
June 28, 2009 at 5:19 am
No. That wouldn't in and of itself make a triangular joind. Here's a great article by Jeff Moden[/url] that defines the triangular join better than I can.
"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
June 26, 2009 at 12:15 pm
I wanted to be sure of the answer before I posted it, but it seems that SQL Server will most frequently pick the index with the most columns. I tried...
"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
June 26, 2009 at 10:54 am
Paul White (6/25/2009)
A quick Google shows several books and articles...
"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
June 26, 2009 at 10:30 am
tosscrosby (6/26/2009)
Steve Jones - Editor (6/26/2009)
Alright, I'm leaving for a week. Behave yourselves on the thread.
Please, please, please...put me in charge. I'll keep these heathens in check! 😀 We already...
"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
June 26, 2009 at 9:16 am
Steve Jones - Editor (6/26/2009)
Going to DC, dropping my son off at the National Youth Leadership Conference for a week, spending some time with my brother, speaking...
"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
June 26, 2009 at 9:14 am
Steve Jones - Editor (6/26/2009)
Alright, I'm leaving for a week. Behave yourselves on the thread.
Have a good time. I'll be going mid next week for a sojourn away from 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
June 26, 2009 at 8:56 am
Viewing 15 posts - 17,086 through 17,100 (of 22,219 total)