Viewing 15 posts - 1,231 through 1,245 (of 1,583 total)
Lowell (1/27/2012)
by design, if the user has EXECUTE permissions, whatever the proc does, whether INSERT/UPDATE/DELETE, the proc will run successfully, and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2012 at 7:20 am
Just so you know, it's the string function that gives you the non-SARGable predicate in the WHERE clause:
WHERE this = that AND
(CONVERT(char(10), a2.timestamp, 120) = @date)
As suggested, changing it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2012 at 10:49 am
If you add in what Gail and Drew have mentioned, you'll most likely see another significant performance gain. Chances are if you're running the optimized version that was provided...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2012 at 10:16 am
Not sure what the limitiations are but since you have SQL Server, the best solution would be to import the access database into a SQL database, and connect the access...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 25, 2012 at 8:10 am
SELECT
EMP_ID,
ROUND(SUM(CAST(EMP_MINUTES_WORKED as money))/60 ,2) [EmpHours]
FROM EmpHours
GROUP BY EMP_ID
?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2012 at 11:53 am
...and then creating a clustered index against the table...
How large is the clustered index? A fair measure of how large your log file needs to be can be...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2012 at 9:29 am
When the job is running actually running it shows the numbers above, after a step has actually completed it records the step number to the last_executed_step_id column in the msdb.dbo.sysjobactivity...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 19, 2012 at 9:22 am
1 - Data loss is not appreciated..Hardly a couple of hours of data should be ok
2 - Full recovery models
3 - Definitely transactional based environment
4 - I didn't understand this?...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 11, 2012 at 11:07 am
Please be more specific:
1) What's an "acceptable" amount of lost data? i.e. Anything since the last full backup? 2 hours of data? 6 hour? NONE?
2) What recovery...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 11, 2012 at 8:22 am
This is a rather large and open question (really more information is needed to more accurately answer your question)...What is the customer's SLA on downtime? What kinds of things...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 11, 2012 at 8:09 am
I've encountered this issue before as well, but usually it's an issue with the network copy (as Dev and Gianluca have already mentioned). Restoring the DB from it's point...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 11, 2012 at 7:52 am
But I'm being somewhat pedantic.
The function is named as returning the job status but is in fact only returning the last executed job step ID.
How is that job step ID...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 5, 2012 at 9:29 am
Correct. I wrote this to monitor job status (instead of using the xp_sqlagent_enum_jobs method - as that results in having to insert the result set into a temp table,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 5, 2012 at 8:21 am
The two functions need to be use together. One returns the guid from the provided name, the other uses the guid to fetch the status
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 5, 2012 at 7:29 am
PLease also attached the data (or a subset of it)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 3, 2012 at 2:47 pm
Viewing 15 posts - 1,231 through 1,245 (of 1,583 total)