Are you using SQL mail (sp_send_dbmail)?  If so, you can use the mail status table in msdb to check on the status of any email.  Look at the "sysmail_%" views.

What sort of help do you want?

Hi all,

I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.

I need to create one more...

Get the Developer Edition, that would allow you to use more RAM and give you many other added capabilities as well.

> Is it a better approach before running the job I can make the initial size bigger? <<

Yes, for sure.  For one thing, it means you can make sure that...

SQL Server Agent provides Alerts that can be configured to do that.  However, they are per server and, indeed, per db for log file counters.

The default trace also contains entries...

Removing NOLOCK / UNCOMMITTED could only slow down the code, it could never speed it up.  Since OP is looking for a performance gain, removing NOLOCK is not the top...

As stated, we really need a query plan.  But this is always true: instead of "(select count(...) ...) > 0" you can just do an EXISTS check.  You don't really...

If you can count on the values being the same length and/or there are only a very limited number of length variations, you could just SUBSTRING the data from the...

I do know that trick, and have used it myself,...

Here's an alternative method, just for the heck of it:

SELECT 
    begin_time, end_time,
    LEFT(end_time, ISNULL(NULLIF(LEN(end_time) - 2, -1), 0)) * 60...

SUM(Revenue) OVER( PARTITION BY Region, Year, Month )

Oops, seems not to be the case.  You just need to set max mem.  Maybe I'm remembering from an earlier version of SQL?!

I thought SQL only locked SQL pages in memory if the max and...

If you do create a tally table, page compress it at 100 fillfactor.  That will save significantly on the overhead of reading the table.  And, since that table is static,...

In SQL Server, the CASE WHEN/THEN results are scalar (single) values only: keywords, operators, etc. are not allowed.  Thus, you need something more like below.

Edit: That said, the expressions within...

• This reply was modified 5 years ago by ScottPletcher.