Viewing 15 posts - 14,851 through 14,865 (of 22,221 total)
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
I do this all the time on my local machines, laptop, workstation, etc., with no issues. I would not suggest you do this on a production system though. Installing &...
"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:38 pm
That process with an INSERT and UPDATE, I'm not shocked that it's deadlocking. You need to wrap it in a single transaction, not with two, which are both wrapped by...
"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:30 pm
And don't forget, while PASS did not create SQL Saturday (Thanks Andy), it does now own it and provides the local groups the support structure so that they can run...
"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 11:53 am
Matt Miller (#4) (6/10/2010)
CirquedeSQLeil (6/10/2010)
Grant Fritchey (6/10/2010)
Jeff Moden (6/9/2010)
...nor do they knock their MVP rings...
Whoa! Hold on a sec... you got a ring? I didn't get a ring. If 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
June 10, 2010 at 8:50 am
GilaMonster (6/10/2010)
Dan.Humphries (6/10/2010)
I do not activly seek such things but I am not sure you would be able to wipe the smile off my face with a sand blaster.
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
June 10, 2010 at 8:39 am
In order to reduce CPU usage, you need to know what is causing the usage to go so high. I'd suggest using the wait states to identify which processes are...
"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 7:54 am
Viewing 15 posts - 14,851 through 14,865 (of 22,221 total)