Viewing 15 posts - 14,551 through 14,565 (of 22,211 total)
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...
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.
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....
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...
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...
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...
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...
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...
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...
August 3, 2010 at 9:33 am
Steve Jones - Editor (8/3/2010)
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...
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...
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...
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...
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...
August 3, 2010 at 8:05 am
Viewing 15 posts - 14,551 through 14,565 (of 22,211 total)