Viewing 8 posts - 106 through 114 (of 114 total)
Another question. Is the recovery interval set to zero? If it not, then SQL will only shrink down transactions within the available time window. (even when set to...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
December 1, 2010 at 11:15 am
Maggie,
Is the tempDB log database set to a simple recovery?
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
December 1, 2010 at 10:17 am
can you send an example of how you are executing the proc?
Also how you actually execute the SELECT manually might point out the problem. I'm curious if...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
November 30, 2010 at 1:09 pm
I believe the following would suffice:
select count(tel1) + count(tel2) + count(tel3) from table1
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
November 30, 2010 at 11:15 am
My guess is one of the other fields does not exist. You are checking the CLIENT_ID field but you are not checking the other fields. Are you sure...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
November 30, 2010 at 9:41 am
How you implemented it is how you do it.
🙂
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
November 29, 2010 at 1:36 pm
I'm not overly familiar with the PREEMPTIVE waits, but the LAZYWRITER_SLEEP is just SQL waiting to run the next checkpoint.
Have you tried running sp_who2 during this time?
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
November 29, 2010 at 1:15 pm
i believe you are looking for the datediff() function.
Try this:
DECLARE @LastRun DateTime
select @LastRun = max(sitDateTime) from mfSitPosition
if datediff(mi,@LastRun,getdate()) > 30
BEGIN
EXEC yourstoredprocname
END
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
November 29, 2010 at 1:03 pm
Viewing 8 posts - 106 through 114 (of 114 total)