Viewing 15 posts - 4,531 through 4,545 (of 18,926 total)
Paul Hunter (7/25/2011)
Ninja's_RGR'us (7/25/2011)
What were the time differences?
They generally range from 1/3 - 1/2 longer for the context switching. I have one person (a mother of twins) that can...
July 25, 2011 at 8:02 am
Tara-1044200 (7/25/2011)
here is the waitinfo ..(174ms)PAGEIOLATCH_EX:DBNAME:50(*)
Keep checking this figure. That's only 1 / 6 of a second wait. So it's a pretty safe bet that the rollback...
July 25, 2011 at 8:00 am
Marios Philippopoulos (7/25/2011)
Perry Whittle (7/23/2011)
Marios Philippopoulos (7/22/2011)
July 25, 2011 at 8:00 am
Tara-1044200 (7/25/2011)
yes, from the actvity monitor (sp_who2) it shows me as rolling back.
sp_whoisactive would also tell you what it's waiting on. I can't help unless you give me more...
July 25, 2011 at 7:38 am
They must not have been submitted yet.
Some series have been completely written in 1 go but others have not. You can confirm by checking the release dates. Some...
July 25, 2011 at 6:57 am
Paul Hunter (7/25/2011)
July 25, 2011 at 6:56 am
Run sp_WhoIsActive to see if the connection is still doing something.
It might be waiting on another ressource to finish.
And no restarting the server won't help. That transaction still has...
July 25, 2011 at 6:54 am
Richard Warr (7/25/2011)
martin catherall (7/25/2011)
It's just a question. Not a test of your psychic ability 🙂True, although common sense can often save despair and heartache.
I always loved his questions. ...
July 25, 2011 at 6:52 am
Toreador (7/25/2011)
Toreador (7/22/2011)
malleswarareddy_m (7/22/2011)
Now onwards i will read the question properly.
How long I wonder before the next QotD where a literal reading of the question leads to the wrong answer,...
July 25, 2011 at 6:50 am
Sean Pearce (7/25/2011)
Ninja's_RGR'us (7/25/2011)
How many rows are getting updated by this?This doesn't sound like you're not changing anything...
The query is to fix incorrect entries, and on this occassion there were...
July 25, 2011 at 6:29 am
Ya after those Hello break, lunch break, e-mail break all you need is a work break. :w00t:
Totally agree on the quiet time. I used to work for a client...
July 25, 2011 at 6:27 am
How many rows are getting updated by this?
This doesn't sound like you're not changing anything...
July 25, 2011 at 6:09 am
Never did / heard of this.
The only way to confirm is to retest everything... which you have to do in any migration anyways...
July 25, 2011 at 6:07 am
Sean Pearce (7/25/2011)
ALZDBA (7/25/2011)
Are you sure that hasn't been an sp_updatestats or so that got launched (e.g. using...
July 25, 2011 at 5:54 am
There's no way it would have made sense to reseed all 3 tables based on your current code (MS point of view).
Why do you want to resuse the identity #?...
July 25, 2011 at 5:16 am
Viewing 15 posts - 4,531 through 4,545 (of 18,926 total)