Viewing 15 posts - 16 through 30 (of 280 total)
As with most QotDs, I try and answer them, right or wrong, before researching the answer, so I can identify gaps in my knowledge rather than score points.
I'm afraid this...
November 1, 2012 at 2:47 am
Ah, I see. msdb..sysschedules will be your friend then, it defines freq_interval, freq_type, etc. and you should be able to join on schedule_id with msdb..sysjobschedules as a filter.
Unfortunately I...
October 30, 2012 at 4:48 am
In the simplest form, with no filters:
SELECT sj.[name],
sjs.next_run_date, sjs.next_run_time
FROM MSDB..sysjobs sj
JOIN MSDB..sysjobschedules sjs ON sj.job_id = sjs.job_id
You...
October 30, 2012 at 4:23 am
IF vs IIF: IF is a logical operator - IF a THEN b ELSE c. Whereas IIF is a construct, meaning 'IF and ONLY IF' and the SQL...
October 30, 2012 at 4:15 am
Check that the user configured in Idera has the correct permissions to view SQL Server Agent jobs, best achieved by assigning that user to a fixed DB role as per...
October 29, 2012 at 7:10 am
It depends on the type of data you're storing. You will need a good handle on the datatypes used in SQL Server (start here: http://msdn.microsoft.com/en-us/library/ms187752.aspx ) to know the...
October 29, 2012 at 7:06 am
This is a nice question, but skating a bit close to the confidentiality line for me I'm afraid. A bit of basic research with Google will uncover which company...
October 26, 2012 at 8:15 am
Grant, that's exactly what I mean. Thanks very much for your reply!
October 18, 2012 at 3:18 am
Absolutely, it's of prime importance to me. My core employable skill is SQL Server and that's what I do for a living, but I often have ideas on things...
October 12, 2012 at 2:17 am
Good question, thank you. Had to read twice to make sure I wasn't missing a 'trick'!
October 12, 2012 at 2:10 am
I normally attend the local SQL Server user group meetings, you'll find them on SQLServerFAQ. You need to pre-register but they're free to attend and while not always easy...
October 9, 2012 at 5:59 am
Overhead will depend on how well you optimise the SQL-side stored procedure, I suppose. My version runs OK but might contribute to a performance problem. You could use...
October 9, 2012 at 5:20 am
Viewing 15 posts - 16 through 30 (of 280 total)