I dislike IIF ... its "familiar" for people that use similar functions in Excel, but I think CASE is better in SQL

IIF only has two outcomes, true/false, and to...

Yeah, that code should do it.

But if you're using the column name "ClientNotes" directly in a SELECT you will get the original column value, not the one after the REPLACEs. ...

Most typically:

select name,count(*) as name_count
from dbo.table_name
where name like '%ra[jm]%' and P = 1

IIF([var1Title] != '', [var1Title] + ISNULL(' - ' + [var1Topic], '') + ISNULL(' - ' + [var1Name], ''), '') AS Item1

I'd avoid a guid if at all possible.

Make sure you have an index keyed first on c1, so that determining the max(c1) is a single, quick seek.  An INSERT of...

SELECT 
    phone_string,
    phone,
    --LEN(phone) AS phone_len,
    CASE WHEN 
    CASE WHEN...

I wouldn't make the Status a key column, since it's likely to change so often, at least in the earlier life stage of the row.  The rows are small anyway,...

Ordinarily, I'd agree but to consider the span of...

But does the Adjacency model actual satisfy BOM requirements?

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...