Viewing 15 posts - 14,566 through 14,580 (of 22,227 total)
It is possible, just thinking about it, for the NULL values to mess you up though. An ORDER BY statement that is working on NULL values could get those values...
"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 12:39 pm
Are you sure the data is the same between the servers? ORDER BY should work the same way, regardless of NULL values. Maybe the databases have different collation settings? That...
"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 12:17 pm
You should look at the OUTPUT clause. You can use that to capture the ID's generated for all the addresses you just inserted.
"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:48 am
You need to determine what "locked up" means. It could be that the procedure recompiled with a bad plan and the queries are running slow, or it could be contention....
"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:42 am
Stefan Krzywicki (8/3/2010)
Grant Fritchey (8/3/2010)
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...
"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:27 am
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
Viewing 15 posts - 14,566 through 14,580 (of 22,227 total)