Viewing 15 posts - 11,041 through 11,055 (of 22,224 total)
Assuming that's an accurate representation of the query, you don't have a WHERE clause. That means you're processing everything in the table. You're not going to be able to improve...
"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
April 24, 2012 at 4:34 am
Now that you have a batched process, the right way to go, you need to worry about how the optimizer is handling it. Do you have an index 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
April 24, 2012 at 4:32 am
Lynn Pettis (4/23/2012)
Grant Fritchey (4/23/2012)
Lynn Pettis (4/23/2012)
Grant Fritchey (4/23/2012)
And I'm out.Oh well, you can't say I didn't try.
Well, we could say it, but we would be lying... 😉
I had...
"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
April 23, 2012 at 3:43 pm
Lynn Pettis (4/23/2012)
Grant Fritchey (4/23/2012)
And I'm out.Oh well, you can't say I didn't try.
Well, we could say it, but we would be lying... 😉
I had to show him one...
"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
April 23, 2012 at 2:57 pm
And I'm out.
Oh well, you can't say I didn't try.
"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
April 23, 2012 at 2:33 pm
riya_dave (4/23/2012)
I AM ALREADY PUTTING IT INSIDE CURSOR BUT ITS REPEATING AGAIN AND AGAIN
I've no doubt you know this, but I'll point it out, just in case, all caps like...
"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
April 23, 2012 at 2:31 pm
Sounds like what you want is a cursor. Read up on those here.
But, please note, that's a very problematic way of dealing with data within SQL Server. Performance is notoriously...
"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
April 23, 2012 at 2:14 pm
riya_dave (4/23/2012)
i need something like untill there is value the loop should go.
i cant give any condition
suppose files
item1
...
"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
April 23, 2012 at 2:03 pm
Brandie Tarvin (4/23/2012)
Hijacking the thread for another book announcement.You can read the details on the top post of my Google+ stream here: Legend of the Beemen
Huge congratulations. Quite 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
April 23, 2012 at 12:10 pm
riya_dave (4/23/2012)
kindly help me
i want insert
insert into #temp3
select I1,account,id from account(p1)
union
select I1 from #temp2
i cant do this coz of union,what are other ways of i...
"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
April 23, 2012 at 9:09 am
jcrawf02 (4/23/2012)
Brandie Tarvin (4/20/2012)
Grant Fritchey (4/20/2012)
"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
April 23, 2012 at 9:05 am
It's parameter sniffing at work. When you use local variables, you get a scan of the statistics (unless a recompile is involved). When you use parameters, you get a search...
"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
April 22, 2012 at 4:31 am
Wait, what was the solution?
"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
April 21, 2012 at 4:27 am
Based on that, you also could just be looking at contention on the second server. However, from what you said, you saw two different execution plans. Two plans are caused...
"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
April 20, 2012 at 9:30 am
If by script you mean you didn't run a stored procedure? It might mean that you're seeing bad parameter sniffing. Which, again, could be caused by differences in statistics.
Remember, I'm...
"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
April 20, 2012 at 8:57 am
Viewing 15 posts - 11,041 through 11,055 (of 22,224 total)