Viewing 15 posts - 14,851 through 14,865 (of 22,227 total)
It really depends on the application. Yes, modifying indexes or even adding indexes, depending on the index, could negatively affect an application. Just as you would with your own apps,...
"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 14, 2010 at 7:14 am
Many congratulations! Publication is a wonderful thing. Well done.
Unfortunately, I'm not much of a gamer any more and don't have this system, so my support will have to be strictly...
"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 14, 2010 at 7:06 am
Jeff Moden (6/11/2010)
"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 14, 2010 at 6:18 am
You can go to the advanced tab for the given step in the Agent job and tell it to retry a set number of times.
"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 11, 2010 at 12:48 pm
It's not rocket science. Just script the stuff you do manually. That's how we built it. Put it together over time, save the script, you'll be up & running 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 11, 2010 at 12:45 pm
We set up an automated process that captures the security on the target system, restores the database, cleans out the old security, cleans up any sensitive data, then applies 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 11, 2010 at 11:50 am
You should take a look at sqlshare.com. They have quite a lot of videos that can teach you skills in SQL Server, including performance tuning.
"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 11, 2010 at 11:49 am
I'd go with a TOP (1) and an ORDER BY on the value. You'll get exactly what you want.
"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 11, 2010 at 11:46 am
Denny Cherry[/url] has a great little explanation of DTC.
"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 11, 2010 at 9:26 am
That was strange. The original text was meant for a different response
"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 11, 2010 at 9:18 am
I agree with Bhuvnesh, but I will add this: minimal access. Only give as much access as you absolutely have to, and no more.
"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 11, 2010 at 9:17 am
GilaMonster (6/11/2010)
Oops.
Ouch. It's kind of shocking, the fundamental ignorance about how these things work that seems to be so wide spread.
"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 11, 2010 at 8:53 am
Jeff Moden (6/10/2010)
Grant Fritchey (6/10/2010)
GilaMonster (6/10/2010)
Dan.Humphries (6/10/2010)
"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 11, 2010 at 6:05 am
Real time monitoring & long term monitoring are different critters, as you're finding. We use Idera now. It can be tuned to capture more data than it's getting out of...
"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 10, 2010 at 12:49 pm
Again, not seeing everything, I suspect it's the two updates that are causing the issue. The INSERT & UPDATE is going to step on multiple pages or rows, in two...
"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 10, 2010 at 12:46 pm
Viewing 15 posts - 14,851 through 14,865 (of 22,227 total)