Viewing 15 posts - 10,681 through 10,695 (of 22,226 total)
Based on that query code for the procedure, you can do the entire thing just by joining the query that fills your cursor to the update statement. You can do...
"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
June 27, 2012 at 4:03 am
vijayarani87.s (6/27/2012)
Thanks Ravi i have changed the code, I am using while loop now...Hope it will not affect my performance in future 🙂
Just so we're clear, a WHILE loop is...
"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
June 27, 2012 at 4:01 am
Lynn Pettis (6/26/2012)
And we have another horror story, Already tried repair, rebuild, detach/attach, backup/restore (no backup prior to this error).
Youch! That's a real horror story.
"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
June 27, 2012 at 3:56 am
Koen Verbeeck (6/26/2012)
Well, I did the best I could.
I 'liked' the book on Amazon, gave it 5 stars and wrote...
"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
June 27, 2012 at 3:55 am
OK, but I'm still in the dark here. You saw slower performance on a server with slower & fewer CPU? That's kind of normal. If your system was well tuned...
"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
June 26, 2012 at 1:30 pm
SQLKnowItAll (6/26/2012)
Grant Fritchey (6/26/2012)
SQLKnowItAll (6/26/2012)
Grant Fritchey (6/26/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
June 26, 2012 at 1:25 pm
Hard to know. What's different about the different servers? Is one faster than another, more memory, more cpu, different kinds of disk storage, different settings on the sQL Server instance,...
"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
June 26, 2012 at 1:15 pm
It sounds like it might be bad parameter sniffing. When the query is running correctly, get a copy of the plan out of cache & store it on the side...
"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
June 26, 2012 at 1:12 pm
SQLKnowItAll (6/26/2012)
Grant Fritchey (6/26/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
June 26, 2012 at 12:56 pm
WayneS (6/26/2012)
SQLRNNR (6/26/2012)
Ick - that sucks.
I'm curious about what is being done to ensure that something like this doesn't happen...
"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
June 26, 2012 at 12:55 pm
Brandie Tarvin (6/26/2012)
Grant Fritchey (6/26/2012)
WayneS (6/26/2012)
I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?
Sorry....
"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
June 26, 2012 at 9:16 am
Oh, and a nice horror story for you all[/url].
"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
June 26, 2012 at 8:56 am
WayneS (6/26/2012)
I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?
Sorry. I'll be down in...
"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
June 26, 2012 at 8:53 am
Not enough information to tell you precisely what the solution might be. Is the disk you moved the storage to in the exact same configuration and speed as the disk...
"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
June 26, 2012 at 7:47 am
Again, not knowing what's happening inside that procedure, I can't definitively say that yes, you can eliminate the cursor. But I'm still very strongly suggesting 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
June 26, 2012 at 6:25 am
Viewing 15 posts - 10,681 through 10,695 (of 22,226 total)