Viewing 15 posts - 14,566 through 14,580 (of 22,222 total)
WayneS (8/3/2010)
What do you'll think about this[/url]? Is there a valid point? Are the people screaming about...
"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
August 3, 2010 at 11:26 am
Stefan Krzywicki (8/3/2010)
Brandie Tarvin (8/3/2010)
Greg Edwards-268690 (8/3/2010)
Hope those in the northern regions have clear skies for the possilbe light show tonight.Light show?
The Northern Lights or meteor shower?
Meteor shower. Scroll down...
"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
August 3, 2010 at 11:16 am
Greg Edwards-268690 (8/3/2010)
So totally off topic -Hope those in the northern regions have clear skies for the possilbe light show tonight.
Greg E
Ditto. We'll be out at a Scout event. It'll...
"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
August 3, 2010 at 11:14 am
DB_Newbie2007 (8/3/2010)
The cost threshold for parallelism option on this server is set to 5.
Window Server 2008 Standard (64-bit).
SQL Server 2008 Standard (64-bit), Version...
"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
August 3, 2010 at 9:35 am
Stefan, good thought on the optimizer dropping out, but both queries went through a FULL optimization process. That means the optimizer thought it had them both right. I'm still wondering...
"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
August 3, 2010 at 9:33 am
Steve Jones - Editor (8/3/2010)
"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
August 3, 2010 at 9:30 am
Stefan Krzywicki (8/3/2010)
WayneS (8/3/2010)
Stefan Krzywicki (8/3/2010)
WayneS (8/3/2010)
Steve Jones - Editor (8/3/2010)
Since this is the water cooler, any comments?http://abcnews.go.com/US/ground-mosque-plan-stirs-controversy/story?id=10670631
There's a quote in this article that sums up my feelings:
"On 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
August 3, 2010 at 9:28 am
DB_Newbie2007 (8/3/2010)
Unfortunately, "ChargeType" is actually my name for a bunch of columns added together in this particular table to list a charge. The tables (dbo.Jan10, dbo.Feb10, etc) are wide...
"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
August 3, 2010 at 8:46 am
DB_Newbie2007 (8/3/2010)
I agree with the previous statement (RIGHT(RTRIM(InvoiceNumber),12) is a performance issue)... the VIEW_InvoiceData table was never intended to be queried against. Unfortunately, the original architect (2007) did 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
August 3, 2010 at 8:28 am
Steve Jones - Editor (8/3/2010)
Since this is the water cooler, any comments?http://abcnews.go.com/US/ground-mosque-plan-stirs-controversy/story?id=10670631
Personally, I have zero issues with a mosque near Ground Zero. But... that particular organization has an agenda...
"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
August 3, 2010 at 8:26 am
The faster query is getting a parallel execution (assuming I'm reading which of the two plans is the faster). That could explain the difference in execution times right there. 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
August 3, 2010 at 8:05 am
jeff.mason (8/3/2010)
"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
August 3, 2010 at 7:56 am
I'd try SQLPing
"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
August 3, 2010 at 7:40 am
I'm not sure that I see a difference either, but, this:
RIGHT(RTRIM(InvoiceNumber),12)
Is going to absolutely kill performance. You can only ever get scans because of that. Functions on columns is 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
August 3, 2010 at 7:32 am
Why are you trying to create an alias of the geography data type with the same name? Just use it as is.
Also, if you try running that script, as defined,...
"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
August 3, 2010 at 6:54 am
Viewing 15 posts - 14,566 through 14,580 (of 22,222 total)