Viewing 15 posts - 3,871 through 3,885 (of 18,926 total)
LOOKUP_BI-756009 (8/2/2011)
Any idea why this sould have...
August 2, 2011 at 3:48 pm
Andrew L. Smith-213145 (8/2/2011)
In some instances, the job hang was not discovered for 2 or more days. The job/plan will hang indefinately at the restore headeronly step until it is...
August 2, 2011 at 3:47 pm
... none to give but I'm listening in.
August 2, 2011 at 3:46 pm
Nice script > briefcasing!.
Had you considered the profiler method to see what was going on? Might have saved you some time.
August 2, 2011 at 3:44 pm
GilaMonster (8/2/2011)
Restart SQL. I've seen it a few times, a restart fixes it.
afraid to ask...
and nothing else?
Couldn't it be that it's waiting a lot on IO to complete the rollback?
August 2, 2011 at 3:42 pm
Did you try contacting the vendor? "Might" have better luck for a fast answer.
August 2, 2011 at 3:40 pm
jez.lisle (8/2/2011)
Ninja's_RGR'us (8/2/2011)
Missing indexes are contained in the actual plan.
If it "only" takes 55 minutes to run...
August 2, 2011 at 3:39 pm
I'm not sure we have the same definition of worked.
Either you need the left join or you don't. This filter cannot be moved around without changing the results.
August 2, 2011 at 3:37 pm
Nevermind my last comment.
There must be blocking somewhere.
What is the rollback waiting on?
--Borrowed from the activity monitor via profiler
SELECT
[Session ID] = s.session_id,
...
August 2, 2011 at 3:32 pm
thirulok_t (8/2/2011)
The shrink never happened. we perform a log backup before the shrink operation.
the backup got stuck, even before the shrink operation.
I ran...
August 2, 2011 at 3:30 pm
Did you try this one?
Ninja's_RGR'us (8/2/2011)
left outer join address awith(nolock)on a.parent02aid = CONVERT(VARCHAR(50), m.acctid )I still think refactoring is the solution if it matters.
August 2, 2011 at 3:27 pm
Beginner_2008 (8/2/2011)
Now it's successful... i repalced 'and ' with 'where'It worked...
thanks..
No it doesn't. What you just did is converted the left join to an inner join. When you...
August 2, 2011 at 3:27 pm
where dt BETWEEN DATEADD(M, -3, GETDATE()) AND GETDATE() (or use @endate if the user needs this as a parameter....
August 2, 2011 at 3:25 pm
Viewing 15 posts - 3,871 through 3,885 (of 18,926 total)