Viewing 15 posts - 14,866 through 14,880 (of 22,227 total)
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
Those are very large topics. I'd suggest starting with reading the Books Online to get the basic concepts down. Once you're there, swing by Paul Randal's blog. He's got tons...
"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:06 am
OUTPUT clause, as stated above, is the best approach, especially because it allows for multiple rows. But if you're only ever dealing with a single row, you can capture 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 10, 2010 at 7:03 am
Based on the information provided, it's hard to know for sure what's causing your deadlock. It looks like two different queries, but it's hard to say. The victim is 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 10, 2010 at 7:01 am
What does it matter which is faster? They are two completely different operations with entirely different purposes. You can't substitute one for the other. If I tell you backup 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 10, 2010 at 6:55 am
Conan The Canadian (6/10/2010)
Right now, I just don't have the time to commit to doing anything large 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 10, 2010 at 6:51 am
Allen is pretty much "the guy" when it comes to this stuff. Sorry the book wasn't helpful, but track down anything he writes. Some of it has to help.
"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 6:13 am
Steve, I'd love to run, really. Not because I have some great ideas for where to take the organization but because I'm willing to get in there & work. However,...
"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 6:04 am
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 had a ring it would be...
"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 5:50 am
Nice point on the INNER JOIN and the issues it causes.
"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 9, 2010 at 3:14 pm
Viewing 15 posts - 14,866 through 14,880 (of 22,227 total)