Update: user wanted two more filtering fields so I added those in and those two *do* show up with a default value of all/NULL (using the default default value of...

Done, but I'm still being forced to select something before the report will run. I want it to auto-run as soon as I open it.

Good questions. Don't think I'll put these on the questionnaire given the tech skills (or rather lack thereof) of the audience but they're definitely good ones to keep in mind.

Lowell, he wanted it scriptable...

Here's where to check the job stuff:

msdb.dbo.sysjobs

msdb.[dbo].[sysoperators]

So in essence you'd get the data from these tables then run the above SP to add the notify. There's...

This is what I get from scripting that:

USE [msdb]

GO

EXEC msdb.dbo.sp_update_job @job_id=N'01cc77f0-9ea0-4e26-9cc5-2cdda24086b5',

@notify_level_email=2,

@notify_level_netsend=2,

@notify_level_page=2,

@notify_email_operator_name=N'DBA'

GO

You'd have to take this and join it with the msdb table to get the job...

Thanks, Craig. SLA's are handled in the main IT intake form. We're just expanding the database part. And yes, when we can (which isn't always possible due to the last-minute...

Frequency of backups depends upon the amount of activity on the database. As a general rule I do nightly full backups and transaction log backups every 30 minutes on our...

This line is the issue:

'IconFile' = CASE WHEN Files.FileName IS NULL THEN Events.IconFile

...

That makes a lot of sense, Drew. I think I'll stick with my solution as I think it's more readable and it looks to be working well, but I'll definitely...

I suspect most of those 14 seconds are from pulling the rows from DB2 into the initial SQL Server temp table - that's always our bottleneck and at this point,...

(umm, that would be "she")

The original code wouldn't do it without a trim as I was dealing with DB2. I *do* have a workaround for the RTRIM now that...

Ninja's_RGR'us (9/20/2011)

---

You need to find a way to whack the rtrim here if you want any shot at an index seek.

RTRIM(u.SourceValue)

I also don't see how you can possibly need it...

Drew:

I wondered about that. Was the only way I could get that TVF to work, though.

doing the trims outside the function isn't really a possibility. So how do I do...

Lowell:

NewValue_Load is the only actual table in the query. That table is truncated and populated anew every day. I have several different flavors of queries that use the function in...

It's a simple string to string translation so I don't think sample data is relevant (especially since in this case it would have to be entirely faked)

The surrounding query is...