Viewing 15 posts - 18,556 through 18,570 (of 22,219 total)
Then, whatever it's doing, it's plodding along. You can kill it, but you might be waiting for a while for the rollback to clear.
"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
January 30, 2009 at 5:55 am
Usually save it as a .sqlplan file and then zip it up and post 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
January 30, 2009 at 5:50 am
Casper (1/30/2009)
Thanks for all your replies but I was now thinking: As mentioned it does UPDATES and INSERTS to...
"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
January 30, 2009 at 5:41 am
Can you post the execution plans?
"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
January 30, 2009 at 5:39 am
They're no good to me dead.
"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
January 30, 2009 at 5:37 am
Things like this will lead to table scans, which will kill your performance:
WHERE
COALESCE(Last_live_insert_date, Last_booked_insert_date)
"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
January 30, 2009 at 5:14 am
Krishna (1/30/2009)
Why dont you run Profiler against the troubled server?Check the events:
TextData
ApplicationName
HostName
LoginName
EndTime
SPID
CPU
Duration
Reads
Writes
Profiler records when a proc, query or statement starts and when a proc, query or statement ends. 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
January 30, 2009 at 4:04 am
Except for the recursion, a CTE is really just a more sophisticated way to create sub-selects. So they're just as effective as the sub-selects were with the added value 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
January 30, 2009 at 4:00 am
So it's two different databases? You can join the tables together in a query by referrencing the database name, but you can't create a foreign key across databases.
"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
January 30, 2009 at 3:55 am
You must be new in this galaxy.
"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
January 29, 2009 at 9:12 pm
Bruce W Cassidy (1/29/2009)
Greg Edwards (1/29/2009)
I'd say that depends on if you got the correct results.:w00t:
[font="Verdana"]Yup. I added a cross join as well. And the full outer joins...
"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
January 29, 2009 at 9:02 pm
Jack Corbett (1/29/2009)
My question is, was 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
January 29, 2009 at 8:59 pm
GilaMonster (1/29/2009)
Bruce W Cassidy (1/29/2009)
sometimes it's fun having a good ol' mud-slinging match with someone who is absolutely sure they are right. And sometimes that's even me!
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
January 29, 2009 at 8:57 pm
Jean-François Bergeron (1/29/2009)
CAST(MfrCode AS NVARCHAR(max)) LIKE 'tel%' AND
CAST(VendorCode AS NVARCHAR(max))...
"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
January 29, 2009 at 1:45 pm
Jean-François Bergeron (1/29/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
January 29, 2009 at 1:05 pm
Viewing 15 posts - 18,556 through 18,570 (of 22,219 total)