Viewing 15 posts - 5,356 through 5,370 (of 5,685 total)
You add an identity column to hold ordering in the same positions they're already stuck in. Then you modify a few things like maxdop to make sure you don't...
October 6, 2010 at 3:11 pm
bitbucket-25253 (10/6/2010)
October 6, 2010 at 3:04 pm
GilaMonster (10/6/2010)
Steve Jones - SSC Editor (10/6/2010)
I suspect it will be tonight now.
Almost certainly. Gonna be all over by tomorrow morning and it's almost bed time for me (approaching...
October 6, 2010 at 3:00 pm
Amit Pandey DeBugSQL (10/6/2010)
Yes I ran the query given by you...
October 6, 2010 at 2:58 pm
Alvin Ramard (10/6/2010)
Tom.Thomson (10/6/2010)
... "Just because I have to be doesn't mean I am" ...I wonder what Descartes would say about that. 😎
Would probably fall under the same header...
October 6, 2010 at 2:55 pm
Shawn Melton (10/6/2010)
Craig Farrell (10/6/2010)Recent posts (Since my last visit). Keeps you on the ball.
Ah..took me a minute to find where that was 😀
And knowing is half the battle!...
October 6, 2010 at 2:35 pm
This query isn't the problem child, but it could be a contributor if default is READ COMMITTED.
EDIT: Whoops. Can you also find out if your READ_COMMITTED_SNAPSHOT is set to...
October 6, 2010 at 2:32 pm
Shawn Melton (10/6/2010)
GilaMonster (10/6/2010)
Tom.Thomson (10/6/2010)
Brandie Tarvin (10/6/2010)
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx
No. I find it professional and well-reasoned. It is the correct and necessary response to...
October 6, 2010 at 2:30 pm
GilaMonster (10/6/2010)
Is today 'Mismanage your transaction log' day?http://www.sqlservercentral.com/Forums/Topic999809-146-1.aspx
3rd one so far today.
Until recently I had no idea how many people screwed up full vs. bulk vs. simple...
October 6, 2010 at 2:19 pm
I believe you're looking for this:
UPDATE tu1
SET
first = tu2.first,
last = tu2.last,
local_ID = tu2.local_id
FROM
#Test_Users AS tu1
JOIN
(SELECT
*
FROM
#Test_Users
WHERE
org_id = 50
) AS tu2
ONtu1.local_id = tu2.local_id
where
tu1.org_id = 50
October 6, 2010 at 2:11 pm
Craig,
Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for you regarding the variable front of the...
October 6, 2010 at 1:54 pm
Answer: No and no.
This code, as is, will not deadlock independently. There's no transaction calls.
What is the serverwide setting for isolation?
October 6, 2010 at 1:43 pm
WayneS (10/5/2010)
October 5, 2010 at 6:08 pm
The Dixie Flatline (10/5/2010)
October 5, 2010 at 5:38 pm
TheSQLGuru (10/5/2010)
3) I gotta say it is a darn shame in this day and age that you are fretting over a paltry 50GB of disk space!! :blink:
Wish I could...
October 5, 2010 at 5:24 pm
Viewing 15 posts - 5,356 through 5,370 (of 5,685 total)