Viewing 15 posts - 14,851 through 14,865 (of 22,211 total)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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,...
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...
June 10, 2010 at 5:50 am
Nice point on the INNER JOIN and the issues it causes.
June 9, 2010 at 3:14 pm
If the BOL isn't helping, try this
June 9, 2010 at 3:06 pm
Viewing 15 posts - 14,851 through 14,865 (of 22,211 total)