Viewing 15 posts - 10,666 through 10,680 (of 22,219 total)
Thanks guys.
"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 8:00 pm
Just understand that the Profiler GUI actually pulls data using a different mechanism than trace events. So, yes, pointing the Profiler GUI at your server will put additional load on...
"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 11:31 am
Cool! Have fun.
"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 11:29 am
Reddy Ksr (6/27/2012)
i think in sql server 2008 we can rollback the committed transaction.but in server 2005 we can't.
can anyone suggest me what will be reason.
Where are you getting this...
"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 6:32 am
If you're in a situation where you start a backup process and during that backup process you start a transaction. Then, the backup process completes, before the transaction. The transaction...
"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:33 am
I'd need to see the actual execution plan.
And I'm with Gail (as usual) nolock = no fun.[/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 27, 2012 at 4:29 am
The DTA relies on statistics from your data and your database as well as the queries that you've captured in your trace events file. It uses those to evaluate 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
June 27, 2012 at 4:19 am
Koen Verbeeck (6/27/2012)
Grant Fritchey (6/27/2012)
Koen Verbeeck (6/26/2012)
Well, I did the best I could.
I 'liked' the book on Amazon, gave 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 27, 2012 at 4:14 am
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
Viewing 15 posts - 10,666 through 10,680 (of 22,219 total)