Viewing 15 posts - 10,666 through 10,680 (of 22,224 total)
Instead of connecting using the server name, which won't be resolving on other domains, you need to use the server IP address and port. Also, you need to be sure...
"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
July 8, 2012 at 4:16 am
There's always the T-SQL Prettifier over at Simple-Talk.
If you're willing to spend some money though, I strongly recommend Red Gate SQL Prompt[/url]. I can't live without it. It not only...
"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
July 8, 2012 at 4:09 am
Gail is an MCM. Amazing, wonderful, and hardly surprising. Well done!
What else did I miss?
"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
July 6, 2012 at 6:50 am
Brendan Wong (7/3/2012)
would you think it better...
"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
July 6, 2012 at 6:35 am
I'm not sure. I'm not seeing the issue, so I don't have any advice.
The one thing I can tell you is that you have the sql handle, so you can...
"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
July 6, 2012 at 6:32 am
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
Viewing 15 posts - 10,666 through 10,680 (of 22,224 total)